How to move the SpotlightManagementFramework database to a different SQL server? (4262283)

How to move the UC Diagnostics database that is named by default SpotlightManagementFramework  to a different SQL server?

In the steps described below OldServer is the server where the SpotlightManagementFramework database is currently hosted and NewServer is the server where the database is going to be moved.

Part A - Stop the Spotlight Services

1. Click Start | Run
2. Type services.msc and click OK
3. Stop the Spotlight Diagnostic Test Engine and Spotlight Distributed Collector services

Part B - Backup and Restore the SpotlightManagementFramework database:

1. On OldServer perform a backup of the SpotlightManagementFramework database. To perform this use either your preferred backup software which is capable of backing up SQL databases or the backup utility with SQL Server Management Studio.
2. On NewServer perform a database restore (restoring from the backup generated in step 1)

Part C - Change the SQL Database configuration information on the Unified Communications Diagnostics server

NOTE: Make sure existing registry keys have been backed up prior to any changes being made

1. Click Start | Run
2. Type regedit and click OK
3. Navigate to one of the following locations to view the Database Connection String:

8.4.1 or later:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest\Spotlight Management Framework\Diagnostic Services

8.4 or earlier:

32-bit Server: HKEY_LOCAL_MACHINE\SOFTWARE\Quest Software\Spotlight Management Framework\Diagnostic Services
64-bit Server: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\Spotlight Management Framework\Diagnostic Services

32-bit Server: HKEY_LOCAL_MACHINE\SOFTWARE\Dell\Spotlight Management Framework\Diagnostic Services

64-bit Server: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Dell\Spotlight Management Framework\Diagnostic Services

1. Double click on the "DatabaseConnectionString" object in the right pane
2. Replace existing SQL information with new SQL server name: Data Source=(leave everything else)
3. Click OK to accept the changes
4. Double click on "SqlServer" object in the right pane
5. Replace existing SQL information with new SQL server name:
6. Click OK to accept the changes
7. Restart the computer to apply all changes.

Launch the Management Console. Click on the Spotlight on Messaging node. Click on Connect to an Exchange Organization. Enter in a Global Catalog server name and reconnect to your Exchange Organization.

Once this is done all existing tests will show in the console again.

Note: Ensure that the Spotlight Diagnostic Test Engine service account has DB.Owner rights on the SpotlightManagementFramework database. Otherwise the Spotlight Diagnostic Test Engine service may fail to start.