Forum Discussion
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.
- threw000Copper ContributorThanks - tried this and did some more digging around. It was due to 3rd party firewall being installed by organisation that I wasnt aware of