Establish the OS connection and associate the connection to the SQL Server connection:
1. Open Spotlight Cloud Diagnostic Server app tool
2. Click the Connections icon
3. Select the SQL Server connection and right-click on it to select Properties option
4. Under the OS Details drop down list, select the associated Windows connection. If one is not found, click the Create icon to create the Windows connection.
5. Click OK to save and close.
6. Under Connections icon, ensure all Windows are enabled and being monitored. Right-click on the Windows connection name to select 'Enable Monitoring' option.
If alarms persists, then this scenario is related to a product issue scheduled to be fixed in the future deployment. Apply one of the following workarounds:
1. Acknowledge the alarms
2. Log into the host of Spotlight Diagnostic Server application
3. Open the Services.msc console of Windows. Locate Spotlight Cloud Diagnostic Server services. Restart the services.
1. From the Spotlight Cloud Diagnostic Server application, select the Alarm Actions icon
2. Click New and define a name to the rule i.e. ‘Suppress unwanted Host Not Available alarms’
3. Enable ‘The details contain’ condition and click ‘following phrases’ at the bottom
4. Click Add and enter the following text and click OK: Host data is not available
5. Enable ‘Suppress the alarm’ action and click Ok
6. Click Ok to close the Alarm Actions window