Wednesday, May 1, 2013

Error: 26 - Error Locating Server/ Instance Specified in SQLServer

Recently I have experienced the following error message when connecting to SQLServer

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: 26 – Error Locating Server/ Instance Specified) (Microsoft SQL Server)

Cause 1: If SQLServer is not allowing remote connections.

Possible solution1:

1. Microsoft Management Studio, Right Click Database Server and go to properties
2. On Security Page, under Server Authentication select “SQL Server and Windows Authentication mode” and click OK
3. Restart SQLServer Service

In case of SQLServer 2005, follow below steps to enable remote connections

1. Click on Startup, go to Program files and Select Microsoft SQL Server 2005--> Configuration tools--> SQL Server Surface Area Configuration

2. Click on “Surface Area Configuration for Services and Connections -->  SQL Server Browser--> Select “Automatic” for Startup type and Apply

Cause 2: TCP Port 1433 or UDP Port 1434 ports are not in Firewall exceptions

Possible solution2: Add exception to allow port TCP Port 1433 and UDP Port 1434 or Turn off Firewall rules


Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com

3 comments:

  1. I got a similar problem with sql server , i have tried every thing but does not connect to database engine & it shows error:26.

    First check database engine is running or not. by going into configuration manager. start > sql server >sql server configuration manager . on the right pane you should see the sql server (mss .. ) should be running state with a green indication.
    IF not the database engine is not running. simply uninstall sql server / format your system if possible and then download sql server 2012 and management studio. from
    https://www.microsoft.com/en-ca/download/details.aspx?id=29062

    Install server first, make sure to add server on installation phase
    by clicking add server and then install management studio. this
    should work.. :)

    @shrii@

    ReplyDelete
  2. I am having this problem in a Win 7 64 bit machine where I had installed LocalDB version of 2014. I get this SQL 26 error. I tried to start the server in services.msc screen but there is no SQL server running there ! Can anyone give me how to resolve this Error 26 issue for a LocalDB 2014 server. Thanks.

    ReplyDelete
  3. Thanks Satishbabu Gunukula for sharing this article with us I was facing the same problem from the past few days and it helps me a lot. I have found another helpful post regarding to the same error. Must see from here: http://www.sqlserverlogexplorer.com/fix-error-code-26/

    ReplyDelete