Check the connection details
The SQL Server Availability Group connection details are entered on the Spotlight Client, Availability Group | Connection Details screen.
From the Spotlight Client
- Click Configure | Connections.
- Right click on the Availability Group connection and select Properties.
- Check the connection details.
- Click Test to test the connection.
Possible things to consider:
Verify a node from the availability group is available and accessible over the network.
Check the address is a valid availability listener: hostname, URL or IP address.
When Use Diagnostic Server credentials is selected then the account running the Spotlight Diagnostic Server is used to connect to the Availability Group.
When filling in the User and Password fields, ensure the database user 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.
Verify WMI is working and returns data properly. Verify TCP Port 135 is open on the Windows server host.
UDP port 1434
If the SQL Server instance is hosted on a Windows server and UDP port 1434 is closed then the port number must be included in the address used to connect Spotlight to the SQL Server instance.