Notes:
- This feature is available only in Spotlight on SQL Server Enterprise.
- High Availability requires SQL Server 2012
To add a new High Availability connection please follow the steps below:
- Click Configure | Connections.
- In the Connection Bar on the left, click "High Availability".
- Double-click "Add new connection".
- Complete the connection details:
- Address
The High Availability Listener: IP address, hostname, or URL.
Please make sure the correct name of the Listener is entered here.
To double check the name please open the Object Explorer in SSMS and check the name there .In the example below the correct name would be avgserver:

- Windows Authentication (using Diagnostic Server credentials)
Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the High Availability listener. - User
A valid user account on the High Availability listener.
Note: Ensure the account has sufficient privileges to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the listener allows this. - Password
The password required to connect the specified user to the High Availability listener.
Please find below some troubleshooting solutions regarding High Availability connections:
SOL109257 - Cannot connect to Availability Group: Login failed for user. [0x80131904]