Provider: SQL Network Interface, error: 26 – Error Locating Server/Instance Specified

After re-install Microsoft SQL Server, when I try to connect to the SQL Server, I have received the error below.
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 Interface, error: 26 – Error Locating Server/Instance Specified

When I try to connect it has already fill in the “Server name” for me, so I assume that is the one. However as from the error message it said “The server was not found or was not accessible”, so I try my computer can find any SQL Server. I find out that I do no need to put the instance name on to the “Server name:” section. E.g. I only need to put the name of the server on the “Server name:” text box and it works.

If you want to discover if there any SQL server that you can connect you can try to following.
In the “Connect to Server” Windows

Click on the drop down list beside the “Server Name:
And click on “Browse”

Then you should be able see the “Browse for Servers” windows.

You can then click on the “+” beside “Database Engine” the see if there SQL Server exist on your local machine, or you can click on the “Network Servers” tab to get a list of SQL server which you can connect over the network.

Hope yu find it useful.

Leave a Reply