I have installed the diagnostic server - spotlight playback on the same server as the database and the Spotlight installation. I am receiving the below error:
High Diagnostic Server - Spotlight Playback Playback error [Connection Error]: Connecting to the instance (local) as the user Spotlight_User_DBA failed : The TCP/IP connection to the host (local), port 1433 has failed. Error: 'null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.'. 30/08/2018 09:27:15
Can anyone help me please?
The user name and password are correct.
Thank you in advance.
This is a generic SQL Server TCP/IP connection error. Could you please review and apply all suggestions in KB Article 44994.
I do not seem to have rights to view the answer to that question. Can you please help?
Hi Char, here are some suggestions that might help you:
1. Ensure that the "SQL Server Browser" service is running on the server hosting the Spotlight Playback database instance.2. TCP/IP SQL Server protocol must be enabled for the Playback database instance:a. Open SQL Server Configuration Managerb. Expand the option SQL Server Network Configuration, highlight "Protocols for MSSQLSERVER". Double click "TCP/IP" to view the properties window. Ensure "Enabled" is set to "Yes", change if not. Select tab "IP Addresses", ensure that the correct TCP port used by SQL Server is indicatedc. Click "Apply" and restart the MSSQLSERVER service3. SSMS connection via TCP/IP is successful:From SSMS on the Diagnostic Server host, click Options inside login window. Under Network Protocol dropdown select TCP/IP option. Under Login tab make connection to the Playback database instance.4. Try using the IP address and port of the SQL Server instance hosting the Spotlight playback database:In Spotlight, click Configure | Diagnostic Server | Playback database and change the Instance field.