How To Reset The SQL Connection String After Moving the AM SQL Database To Another SQL Server (4341971)

After moving the AM SQL database to another SQL server, the ArchiveManager Configuration Console return the next possible errors:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server".

"The Configuration Console ran into an exception"

"An invalid connection string was detected, please reconfigure"

The connection string is incorrect and all Archive Manager services will not be able to run until the SQL connection string is connected.

Workaround 1: Modifying the Registry

This workaround involves modifying the Windows Registry to adjust the connection string used by Archive Manager. Follow these steps carefully:

1. On the Archive Manager (AM) server, click "Start," and in the "Run" dialog box, type "Regedit" and press Enter.

2. Navigate to the appropriate registry key based on your operating system type:

   For 64-bit systems:

   HKLM\Software\Wow6432Node\Aftermail

3. Before proceeding, it's crucial to create a backup of the entire registry branch:

   • Select the "Aftermail" key in the left pane.
   • Go to "File" -> "Export."
   • Save the export as a .REG file in a secure location. This serves as a backup in case anything goes wrong.

4. Locate the key named "ConnectionString" within the "Aftermail" registry key.

5. Modify the value of "ConnectionString" to be plain text, ensuring it matches your SQL Server configuration:

   server=SQLSERVER;Trusted_Connection=yes;database=ArchiveManager

   Note: Make sure you replace "SQLSERVER" with the actual name of your SQL Server.

6. Save your changes in the Registry Editor.

Workaround 2: Rebuilding the Encrypted String

This workaround involves using Command Prompt to rebuild the encrypted connection string for Archive Manager:

1. On the Archive Manager server, open Command Prompt.

2. Navigate to the "C:\Program Files (x86)\Quest\Archive Manager\Prerequisites\DatabaseInstaller" directory using the cd command:

   cd "C:\Program Files (x86)\Quest\Archive Manager\Prerequisites\DatabaseInstaller"

3. Run the following command to regenerate the encrypted connection string. Replace "SQLSERVER" with the name of your SQL Server:

   Quest.AM.Setup.DatabaseInstaller.exe -c -server=SQLSERVER -database=ArchiveManager

This command will rebuild the encrypted connection string for Archive Manager based on your SQL Server configuration.