Unable to connect to MSSQL server

Created:

2016-12-12 03:48:07 UTC

Modified:

2017-08-08 13:10:29 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to connect to MSSQL server

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

Unable to connect to MSSQL using SQL Management Studio from a remote server:

Connect to Server
------------------------------
Cannot connect to 203.0.113.2\MSSQLSERVER2012.
------------------------------
ADDITIONAL INFORMATION:
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: SQL Network Interfaces, error: 26 -
Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Connection over telnet is not possible too:

C:\Users\Administrator>telnet 203.0.113.2 1433
Connecting To 10.10.10.10...Could not open connection to the host, on port 1433: Connect failed

Cause

Network issue.

Resolution

Contact your network administrator to allow connection to 203.0.113.2 server over 1433 port.

Have more questions? Submit a request
Please sign in to leave a comment.