Click here to Skip to main content
12,887,768 members (32,265 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


Posted 10 Jan 2014

Solution: Error: 26 – Error Locating Server/Instance Specified

, 10 Jan 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
Solution to a very common problem that we face while working with SQL


This is a very common problem that we face while working with SQL (be it any version of SQL) and we always spend some time to figure out the exact issue. Every time, we need to look into where we should start looking for the problem. This post lists the basic issues that can cause this error and I will keep this post updated in case any more reasons are found.

Below are the most common issues due to which we get this error:

  • Check the Server name – First and the most common thing to check is to ensure there are no typo errors for the server name.
  • Accessibility to Server – The server should also be accessible from the network computer, we are trying to access SQL Server.
  • Check the Instance name – Once the server is checked for correctness, the next thing to check is the SQL Server instance name. Check for typo errors in the Instance name and also ensure that the Instance exists on the server
  • Remote Connections enabled on SQL Server – Ensure SQL Server is allowed for remote connections
  • Mixed Mode Authentication Enabled – Ensure Mixed-mode authentication is enabled on SQL Server you are trying to connect to
  • SQL Browser Service should be running – On the server, SQL browser service should be running. You can check this from Services window on the server.
  • Firewall is configured on server to allow sqlbrowser.exe and port 1434 under exception.

After following all the above steps, the error should be resolved.

[Original Source]

Hope you like this post. You can get connected with me on Facebook, Twitter or LinkedIn also. In case you know any other way of resolving the feature, let me know via comments.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Nitesh Luharuka
Team Leader Director @ Rebin Infotech
India India
An Independent IT Professional and Consultant on MS Technologies like .Net | MVC | Silverlight | Sharepoint | MS Project Server along with open source CMS Systems like DotNetNuke etc.

I am an enthusiastic technocrat who love to debug problems and solve them. I love writing articles on my website in my spare time. Please visit my Website for more details and subscribe to get technology related tips/tricks.

You may also be interested in...


Comments and Discussions

QuestionMessage Removed Pin
JasonClark034-Feb-16 2:14
memberJasonClark034-Feb-16 2:14 
QuestionMessage Removed Pin
johnwalker1011-Jan-16 0:04
memberjohnwalker1011-Jan-16 0:04 
QuestionDisabled SQL Server Browser Service after install Pin
Member 1207743521-Oct-15 14:24
memberMember 1207743521-Oct-15 14:24 
AnswerRe: Disabled SQL Server Browser Service after install Pin
Nitesh Luharuka29-Oct-15 0:47
professionalNitesh Luharuka29-Oct-15 0:47 
GeneralMy vote of 3 Pin
Mxolisi Zondi21-Jul-15 19:40
memberMxolisi Zondi21-Jul-15 19:40 
GeneralRe: My vote of 3 Pin
Nitesh Luharuka21-Jul-15 21:37
memberNitesh Luharuka21-Jul-15 21:37 
GeneralRe: My vote of 3 Pin
Mxolisi Zondi21-Jul-15 22:34
memberMxolisi Zondi21-Jul-15 22:34 
GeneralRe: My vote of 3 Pin
Nitesh Luharuka21-Jul-15 22:55
memberNitesh Luharuka21-Jul-15 22:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170424.1 | Last Updated 10 Jan 2014
Article Copyright 2014 by Nitesh Luharuka
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid