SQL Server 2012: Error Locating Server/Instance Specified - Can log onto Instance on Server using Windows auth, but not from my dev box

Posted on 2013-05-15
Last Modified: 2013-05-15

I'm having a bit of an issue connecting to a SQL Server from my management console.  I can remote desktop onto the server and log onto sql server via the management console on that server, however when I attempt to log onto it via my development box, I receive the error:

SQL Network Interfaces: error 26:- error locating server/instance specified

I am attempting to connect to <server>\SQLEXPRESS - If I remove \SQLEXPRESS I get the named pipes error

Any ideas?  thanks
Question by:krapvag
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 10

Accepted Solution

Matt Bowler earned 500 total points
ID: 39167494
Is the SQL Browser service running?

Is there a firewall involved? If there is - you'll need to open an incoming port rule for UDP 1434.

Can you verify that the SQL instance is configured to accept remote connections?

Open SQL Server configuration manager and check the SQL Server network protocols - is TCP/IP enabled?

Instead of <server name>\SQLEXPRESS what happens if you use <IP address>\SQLEXPRESS?

Author Comment

ID: 39167509
Hi, thanks for your time

SQL Server browser running

Don't think there's a firewall issue

It is accepting remote connections

Named Client seems to have TCP/IP enabled, but not Express

No difference between IP and server name

Author Comment

ID: 39167523
wait a minute, I've enabled TCP/IP for the SQL Express in Configuration Manager and this seems to have resolved it.


Author Closing Comment

ID: 39167524
thanks for the list of possibilities to work through

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question