Check the connection details
The Analysis Services connection details are entered on the Spotlight Client, Analysis Services | Connection Details screen.
From the Spotlight Client
- Click Configure | Connections.
- Right click on the Analysis Services connection and select Properties.
- Check the connection details.
- Click Test to test the connection.
Address
Verify the address is a valid server name, server instance name or IP address.
Connection
Verify the Windows server hosting the Analysis Services server is correct. If the Windows server host is not in the list of connections then add it to the list.
Verify the host is in a domain. Spotlight cannot monitor SQL Server Analysis Services when the Windows host is in a workgroup.
WMI Operability
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 or Azure SQL Managed 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 or Azure SQL Managed instance.
SQL Server availability
Verify the SQL Server Analysis Services server is available and accessible over the network.