• State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 7 subscribers
  • Views 5381 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Spotlight Playback Playback error [Connection Error]

charlene cassar
over 5 years ago

Hi,

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.

Char

Parents Reply Children
  • 0 over 5 years ago in reply to charlene cassar

    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 Manager
    b.    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 indicated
    c.    Click "Apply" and restart the MSSQLSERVER service

    3. 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.

    Gita
    Spotlight Team