Solved

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
4
473 Views
Last Modified: 2013-05-15
Hi,

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
0
Comment
Question by:krapvag
  • 3
4 Comments
 
LVL 9

Accepted Solution

by:
MattSQL 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?
0
 
LVL 1

Author Comment

by:krapvag
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
0
 
LVL 1

Author Comment

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

Thanks
0
 
LVL 1

Author Closing Comment

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now