No Process Is on the Other End of the Pipe

Question

I receive this error when I try to connect to SQL Server 2005. I have enabled TCP/IP, Named Pipes, and restarted the server but that is not working.

Answer 1

I tried the troubleshooting steps in both microsoft tech articles, and oddly no luck.

I managed to fix the solution by changing my authentication from SQL Server Auth to Windows Auth. Though I am not sure the technical reason why this works?

Answer 2

FYI, I've just had the same error.

I switched to Windows authentication, disconnected, then tried to login again with SQL authentication. This time I was told my password had expired. I changed the password and it all worked again.

Answer 3

In my case make sure that your connection string has ;password=

Answer 4

I encountered this problem when the password for the login that I was attempting to connect with had expired.

Answer 5

I assume you have seen this: http://technet.microsoft.com/en-us/library/ms175496.aspx

how about this? http://blogs.msdn.com/sql_protocols/archive/2006/07/26/678596.aspx

Answer 6

I got this error when I (deliberately) reduced the configuration of maximum SQL Server memory to 16Mb and restarted.

So it might be a memory issue.