Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an issue with connecting to SQL Server 2005 x64 SP 4 on Windows 7 x64 with Visual Studio 2008 DataBase edition. I always receives message about error 26 and named pipes provider. It is irrational because I have disabled firewall, enabled named pipes protocol, enabled sql server browser, enabled remote connections etc. Do anybody have an idea why it is happening? :( Please help.

share|improve this question
    
Is this the 2008 R2 GDR version? –  jl. Nov 30 '10 at 18:07

2 Answers 2

It sounds like you already found the article: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

In addition to what is covered in the article, I would be curious to know if you can connect to a different instance or using a different protocol (TCP/IP).

Any clues in the event log?

Is this a named instance?

share|improve this answer
up vote 0 down vote accepted

Ok I found the resolution. Visual Studio Database edition keeps connection string to sql server it two places. (two different text boxes - sic!)

Those places are:

1.Options->Database Tools->Data Connections

2.Options->Database Tools->Design-Time Validation Database

If you have named instance you have to put there only the name of a instance without host name.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.