Forum Discussion

threw000's avatar
threw000
Copper Contributor
Jul 11, 2023

Error connecting to SQL Server using another machine SSMS

I am getting the below error when trying to connect to SQL Server

 

I have searched around and ensured all settings are configured correctly, service running, rules in firewall, correct TCP, etc. It was working well however since stopped working without me changing any settings.

 

SQL Server Authentication all correct

I have even gone into the local PC where the SQL is located, i can connect without any issues and I have reset the password for the profile which is Admin

 

I am using server type: Database engine (I am putting in here the IP address and I have checked and it is still correct)

Server Name: IP address

Authentication: SQL Server Authentication

 

Please help

 

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

 

  • Hi threw000 --

     

    As a quick first test, use test-netconnection to ensure that connectivity to the SQL Server is actually being established.

    test-netconnection -computername <servername or IP address here> -port 1433

    Successful output will appear similar to that shown below.   Take care.

     

  • Hi threw000 --

     

    As a quick first test, use test-netconnection to ensure that connectivity to the SQL Server is actually being established.

    test-netconnection -computername <servername or IP address here> -port 1433

    Successful output will appear similar to that shown below.   Take care.

     

    • threw000's avatar
      threw000
      Copper Contributor
      Thanks - tried this and did some more digging around. It was due to 3rd party firewall being installed by organisation that I wasnt aware of

Resources