Error 40: Named Pipes Provider -couldn't open connection to SQL server 2005
Whenever I try debugging my application, developed in visual studio 2005, I get the following error message:
"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 setting SQL server doesn't allow remote connection. (provider: named pipes provider, error 40 - could not open a connection to SQL server)"
The problem is I'm not even trying to connect to SQL server 2005, but rather trying to connect to SQL server 2000. I tried runningC:\Windows\Microsoft.NET\v2.0.50727\aspnet_regsql.exe
to fix the problem but nothing has changed. read so many articles, tried them
none worked. Any suggestion greatly appreciated.

