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

9 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
  4. This article was written by a real thinking writer without a doubt. I agree many of the with the solid points made by the writer. I’ll be back day in and day for further new updates. dotcom secrets

    ReplyDelete
  5. Greetings from Colorado! I'm bored to tears at work so I decided to check out your website on my iphone during lunch break. I love the info you provide here and can't wait to take a look when I get home. I'm amazed at how quick your blog loaded on my mobile .. I'm not even using WIFI, just 3G .. Anyhow, amazing blog!diaries and notebooks

    ReplyDelete
  6. You can definitely see your skills in the work you write. The arena hopes for even more passionate writers like you who aren't afraid to say how they believe. At all times go after your heart.Power Exportation

    ReplyDelete
  7. Hello there! I could have sworn I've been to this website before but after checking through some of the post I realized it's new to me. Anyhow, I'm definitely glad I found it and I'll be bookmarking and checking back often!moneylender Singapore

    ReplyDelete
  8. Thank you so much for sharing nice post UK Essays

    ReplyDelete