Check the connection details
The SQL Server Replication connection details are entered on the Spotlight Client, SQL Server Replication | Connection Details screen.
From the Spotlight Client
- Click Configure | Connections.
- Right click on the SQL Server Replication connection and select Properties.
- Check the connection details.
- Click Test to test the connection.
Verify the address is a valid connect string for a distributor database in the replication environment: a server name, server instance name or IP address.
When Use Diagnostic Server credentials is selected then the account running the Spotlight Diagnostic Server is used to connect to the SQL Server Replication environment.
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 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.
SQL Server availability
Verify the SQL Server Replication environment is available and accessible over the network.