0

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.

truthseeker
  • 157
  • 2
  • 7

2 Answers2

0

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?

unhappyCrackers1
  • 977
  • 1
  • 6
  • 18
0

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.

truthseeker
  • 157
  • 2
  • 7