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.
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?
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.