After renaming the server where the Recovery Manager for Exchange databases are hosted on when opening the Recovery Manager for Exchange console, Or if the SQL server service is not running or offline you see the following error and the console will not open:
"An error occurred while initializing the storages database. Details: An error occurred while connecting to the storages database using the connection string
"DATABASE=RME-Storages-ServerName;SERVER=ServerName\QUESTRMEX;Integrated Security=SSPI;".
Details: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Note: By Default the Recovery Manager for Exchange databases are local to Recovery Manager. If you rename the server the same problem will happen.
1. Update the Connection Strings in the registry (regedit) under "HKEY_LOCAL_MACHINE\SOFTWARE\Quest Software\Recovery Manager for Exchange"
- Backup Catalog
- EDB Information
- Storages
2. Download and Install SQL Server Management Studio Express 2008 on the Recovery Manager for Exchange (RME) server. If the SQL server is remote, open SQL Server Management Studio on the remote SQL server and skip to step 4 and continue.
Note: When installing SSMSE 2008, choose new instance as that is the only way to install the tools.
3. While logged in with the Service Account for Recovery Manager for Exchange open SQL Server Management Studio Express.
4. Connect with Windows Authentication to New_Servername\QUESTRMEX
5. Click New Query
6. Run select @@servername and confirm the old SQL server is listed.
7. Copy into notepad the below query:
sp_dropserver "Old_Server\QUESTRMEX";
GO
sp_addserver "New_Server\QUESTRMEX", local;
GO
8. Update the query replacing "Old_Server" with the old server name, and then "New_Server" with the renamed server name.
9. Copy & Paste the query into the new Query window in SSMSE 2008.
10. Highlight the query and click Execute.
Note: If you run select @@servername again it may display the old server name, even though it was updated. If you re-run sp_addserver it will display the Server <ServerName> Already exists. That is ok, move on to Step 11.
11. Restart the SQL Server Instance by right-clicking from the Left-pane the Servername\instance and click Restart
12. Open Add/Remove Programs, Select Recovery Manager for Exchange and click Change.
13. Choose Repair.
14. Allow the repair to complete.
15. Open Recovery Manager for Exchange
