Unable to start the DataManagerSLAD and DiagnosticTestEngineSLAD services after renaming the server that hosts Spotlight on Active Directory. The SLAD database also exists on the same server.
CAUTION: Incorrectly editing the registry may severely damage your system. Before making changes to the registry, you should back up any valued data on the computer.
1. Stop the SLAD services: DataManagerSLAD, DiagnosticTestEngineSLAD, Distributed Collector
2. Change the following registry entries to the new host name of the SQL Server(New Name of the Machine):
HKEY_LOCAL_MACHINE\Software\Quest Software\Spotlight on Active Directory\DbServerName | DatabaseServerName.
HKEY_LOCAL_MACHINE\Software\Quest Software\DiagnosticTestEngine | DatabaseServerName
3. Change the "ImagePath" string for the 2 SLAD services to point to the new DB host machine, by making the following registry changes:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DataManagerSLAD
String Value: ImagePath has the database connection string that needs to be changed. Change the "Data Source" in the connection string.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DiagnosticTestEngineSLAD
String Value: ImagePath has the database connection string that needs to be changed. Change the "Data Source" in the connection string.
4. Start the DataManagerSLAD & DiagnosticTestEngineSLAD services.
5. If you have Web Reports installed, open the following file and change the SQL Server Name, Select the SLAD database from the Database drop-down menu, and enter any new credentials if using SQL Authentication: C:\Program Files\Quest Software\Spotlight on Active Directory\Web Reports.udl.
6. Backup your SLAD database using SQL or third party tools
7. Launch SQL Management Studio
8. Open dbo.T_Agents table
9. Modify the HostServerFQDN section to match the new server name
10. Start the SLAD services: DataManagerSLAD, DiagnosticTestEngineSLAD, Distributed Collector
If the SLAD database is installed on another server, there is no need to update the registry keys. The HostServerFQDN table will only need to be modified.
