Error: An error occurred while attempting to make the selected archive database active (4375962)

We have identified a defect when attempting to work with archive databases in an environment where older archive databases (pre-8.6) exist. In 8.6 two new properties were added to the XML file where this information is stored to allow SQL style authentication. With older entries in the file these will be missing. Adding the missing elements will correct the issue for the customer as a workaround.

To correct these entries:

On the AA server navigate to "C:\Program Files\Quest\Active Administrator\Server"

Edit ActiveAdministrator.xml as an administrator.

Find any archive entries that match the format below in this file:
 

-- Old entry start --

<Archive>

   <ID>5a11421c-27d8-4e99-b806-a6186b96fe27</ID>

   <Name>ArchiveName</Name>

   <Active>False or True</Active>

   <ServerName>ServerShortName</ServerName>

   <DatabaseName>ActiveAdministrator_Archive_Name</DatabaseName>

   <IntegratedSecurity>True</IntegratedSecurity>

   <ConnectionTimeout>15</ConnectionTimeout>

   <EncryptConnection>True</EncryptConnection>

   <TrustServerCertificate>True</TrustServerCertificate>

   <Description></Description>

  </Archive>

-- Old entry end --
 

Then modify this entry to match the changes below. Note the two new empty properties added before the <Description> tag. This must be done for any entry matching the old format.

-- Correct New Entry Format --

<Archive>

   <ID>5a11421c-27d8-4e99-b806-a6186b96fe27</ID>

   <Name>ArchiveName</Name>

   <Active>False or True</Active>

   <ServerName>ServerShortName</ServerName>

   <DatabaseName>ActiveAdministrator_Archive_Name</DatabaseName>

   <IntegratedSecurity>True</IntegratedSecurity>

   <ConnectionTimeout>15</ConnectionTimeout>

   <EncryptConnection>True</EncryptConnection>

   <TrustServerCertificate>True</TrustServerCertificate>

   <DatabaseUserName></DatabaseUserName>

   <DatabasePassword></DatabasePassword>

   <Description></Description>

  </Archive>

-- End Correct New Entry Format --

Making this change should correct the issue for the customer and allow them to change active archive databases.

Defect ID for this issue is VSTS000411117