SQL Server Replication | Connection Details
|
|
Note: Connections to SQL Server Replication is available for SQL Server 2005 and later. |
Open this screen from the Spotlight Client
-
Click Configure | Connections.
- Select the Replication connection type.
- Click Add a new connection or to edit, right click the connection and select Properties.
Specify the connection details for this SQL Server Replication environment
| Field | Description |
|---|---|
|
Address |
The connect string for a distributor database in the replication environment. That is the: Server Name, Server Instance Name, or IP address. |
|
Authentication |
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. |
|
|
TIP: When done, click Test to verify Spotlight can successfully establish a connection with the details provided. |