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.
A:
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
Sam
2009-01-16 22:56:54
A:
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?
Sheehan Alam
2009-01-17 20:23:23
A:
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.
Finch
2010-08-26 07:09:50