Monitor SQL Server Analysis Services by supplying the following connection details to Spotlight.
How to enter / edit connection details
Use a Spotlight Client to enter / edit connection details.
From the Spotlight Client
- Click Configure | Connections.
- Double click Add new connection.
- Fill in the connection details.
Connection details
Address
Specify the connect string to link to the Analysis Services server (that is, the Server name, Server Instance name, or IP address).
Instance
The instance name of the Analysis Services server. This is filled in automatically by Spotlight as the content to follow “/” in the address.
Connection
Select the Windows server hosting the Analysis Services server. This is required. If the Windows server host is not in the list of connections then click Create to add it to the list.
Tip: Click Create to add a Windows server to the list. This opens Windows server | Connection Details.
Test the connection
On entering / modifying connection details in the Spotlight Client, click Test to test the connection.