Add Connections
From the Spotlight Client
- Click Configure | Connections.
- Double click Add new connection. You may be prompted to fill in the New Connection Details dialog.
- You will be prompted to fill in the connection properties.
The connection properties for a new connection are entered on two tabs: Details and Tags. The connection details are required. The details are dependent on the connection type.
- Connection Details for Analysis Services
- Connection Details for Availability Group
- Connection Details for Azure SQL Managed Instance
- Connection Details for SQL Azure
- Connection Details for SQL Server
- Connection Details for SQL Server Replication
- Connection Details for Unix/Linux server
- Connection Details for VMware
- Connection Details for Windows server
- Connection details for Hyper-V
Connection Tags are optional. Connection Tags are a free form organizational tool that may be applied to Spotlight connections. Tag names represent a project, geographic region or other indicator of interest to you and your organization. Multiple tags can be assigned to one connection.
Discover Connections
The Connection Discovery Wizard is used to locate resources on the network and add those resources as Spotlight connections. The Connection Discovery Wizard can be used to locate SQL Server instances or Windows Servers.
From the Spotlight Client
- Click Configure | Connections.
- Double click Discover from the list of All connections, SQL Server or Windows.
Diagnose Connections
From the Spotlight Client
- Click Configure | Connections.
- Double click on the connection or click Diagnose to open the Spotlight Overview page for the connection.
Edit Connection Properties
From the Spotlight Client
- Click Configure | Connections.
- Right click on the connection and select Properties.
The connection properties for an existing connection are shown on three tabs: Details, Tags and Monitoring.
Details
The connection Details are dependent on the connection type.
- Connection Details for Analysis Services
- Connection Details for Availability Group
- Connection Details for Azure SQL Managed Instance
- Connection Details for SQL Azure
- Connection Details for SQL Server
- Connection Details for SQL Server Replication
- Connection Details for Unix/Linux server
- Connection Details for VMware
- Connection Details for Windows server
- Connection details for Hyper-V
Tags
Replace / add / delete Tags for the connection. Tags are a free form organizational tool that may be optionally applied to Spotlight connections. Tag names represent a project, geographic region or other indicator of interest to you and your organization. Multiple tags can be assigned to one connection.
Monitoring
Use the Monitoring tab to edit connection monitoring settings.
Delete the connection
From the Spotlight Client
- Click Configure | Connections.
- Right-click on the connection and select Delete.
If you have customized the alarms set for this connection or the scheduling information then those customizations will be deleted with the connection. You may like to backup your customizations before you delete the connection. To do so, backup the \Agent\Conf folder in the Spotlight Spotlight Diagnostic Server installation folder.