Forum Discussion

threw000's avatar
threw000
Copper Contributor
Jul 11, 2023
Solved

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. I...
  • bake13's avatar
    bake13
    Jul 13, 2023

    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.

     

bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jul 13, 2023

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
Jul 13, 2023
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