Connection to SQL Server

Gololo

Reputable
Oct 18, 2014
2
0
4,510
I keep on getting the following error message:

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)
 
Solution
Ensure that the server is actually at the IP/FQDN that the program expects it to be, and isn't blocked by a firewall. Check that the username/password is correct.

Try accessing the server through a command-line interface (not so sure how to do this with MSSQL; I usually deal with MySQL).

Gololo

Reputable
Oct 18, 2014
2
0
4,510
We have a program that uses SQL server. I'm unable to establish connection.
I have uninstalled and reinstalled SQL, but still has a connection problem.
 
Ensure that the server is actually at the IP/FQDN that the program expects it to be, and isn't blocked by a firewall. Check that the username/password is correct.

Try accessing the server through a command-line interface (not so sure how to do this with MSSQL; I usually deal with MySQL).
 
Solution