Link to home
Start Free TrialLog in
Avatar of Member_4438002
Member_4438002

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of Matt Bowler
Matt Bowler
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_4438002
Member_4438002

ASKER

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
wait a minute, I've enabled TCP/IP for the SQL Express in Configuration Manager and this seems to have resolved it.

Thanks
thanks for the list of possibilities to work through