Spotlight is giving connection errors upon startup.
Spotlight cannot connect to the playback database <dbname> on the instance <DB Instance Name>.
The Spotlight Statistics Repository could not be connected to. The error is: com.microsoft.sqlserver.jsbc.SQLServerException: The TCP/IP connection to the host has failed. Java.net.ConnectException: Connection refused: Connect
RESOLUTION 1:
1. Ensure that the "SQL Server Browser" service is running
2. TCP/IP SQL Server Protocol must be enabled.
a. Open SQL Server Configuration Manager
b. SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER | TCP/IP | Choose Enabled Yes | Under IP Addresses tab, ensure that the correct TCP port used by SQL Server is indicated
c. Click Apply and restart the MSSQLSERVER service
3. Named Pipes SQL Server Protocol must be enabled.
a. Open SQL Server Configuration Manager
b. SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER | Named Pipes | Choose Enabled Yes | Click Apply
c. Restart the MSSQLSERVER service
4. From the Diagnostic Server (DS) machine, check if the DS user indicated when creating the Playback Database can connect remotely via TCP. Open the command prompt and run:
sqlcmd -U <username> -P <password> -S <SQL_instance>,<TCP_port>
e.g.
sqlcmd -U sa -P sa -S SQLSERVER,1433
5. Restart the Diagnostic Server service
RESOLUTION 2:
1. Schedule a maintenance time and reboot the server. This will resolve the issue.
