Page History

...

Get a New SQL Diagnostic Manager License Key

...

1. Use SQL Server Enterprise Manager or Management Studio to close any open connections to the Repository database.
2. Use SQL Server Enterprise Manager or Management Studio to take the Repository database offline. If you cannot take the Repository database offline, stop the Collection Service.
3. Use a tool such as IDERA SQLsafe SQL Safe to restore the Repository database on the target server using the appropriate backup archive file.

...

1. Select Start > Administrative Tools > Services on the current computer.
2. Scroll down and right-click SQLdm SQLDM Collection Service in the list, and select Properties.
3. In the Startup Type drop-down list, select Disabled.
4. Click OK.
5. Scroll down and right click SQLdm SQLDM Management Services in the list, and select Properties.
6. In the Startup Type drop-down list, select Disabled.
7. Click OK.

...

1. Open the SQL Diagnostic Manager Console.
2. Enter your new SQL Diagnostic Manager license key.
3. Add the SQL Server instances you want to monitor.
4. Open the System Diagnostics utility by selecting Help > System Diagnostics.
5. Click Test.
6. Verify that all the tests are successful.