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.

1
  • Is this the 2008 R2 GDR version?
    – jl.
    Nov 30, 2010 at 18:07

2 Answers 2

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.

0

It sounds like you already found the article: Link

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?

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .