Monitor a SQL Server Replication environment 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

  1. Click Configure | Connections.
  2. Double click Add new connection.
  3. Fill in the connection details.

Connection details

Address

Specify the connect string for a distributor database in the replication environment.

That is the: Server Name, Server Instance Name, or IP address.

Authentication

Specify the authentication for Spotlight to use to connect to the SQL Server Replication environment.

Select Windows Authentication (using Diagnostic Server credentials) to use the Windows user configured to run the Spotlight Diagnostic Server.

Alternatively, fill in the User and Password fields.

Connection Failure Properties

Set the connection timeout and the number of times Spotlight should attempt to connect to the Replication before raising the Connection Failure alarm.

Test the connection

On entering / modifying connection details in the Spotlight Client, click Test to test the connection.