SOLVED

Error connecting to SQL Server using another machine SSMS

Copper Contributor

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)

 

2 Replies
best response confirmed by threw000 (Copper Contributor)
Solution

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_0-1689253225668.png

 

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
1 best response

Accepted Solutions
best response confirmed by threw000 (Copper Contributor)
Solution

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_0-1689253225668.png

 

View solution in original post