attaching sql server 2005 database issue

[cbrown777]

I have already tried a number of ideas from others on how to get a successful connection to a sql server 2005 database in visual studio 2005.

When I test connection I get this error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have ms sql server 2005 developer edition and I am on vista. Any help would be appreciated.

 

[gmmastros]

Look here: faq962-5481

Also, since you are using vista, the new firewall also blocks outgoing ports. Read more here.

http://www.microsoft.com/technet/community/columns/cableguy/cg0106.mspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom