SQL - an error occurred during the pre-login handshake
- by Rivka
Until yesterday evening, I was able to connect to my server from my local machine. Now, I get the following error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) (.Net SqlClient Data Provider)
Note, I can log on to the actual server with no problem.
Yesterday, I installed IIS on my machine and set up a site using my IP address - don't know if this has anything to do.
I did come across this article, followed the steps, but didn't seem to help.
http://www.escapekeys.com/blog/index.cfm/2011/1/26/Microsoft-SQL-Server-Error-64-A-connection-was-successfully-established-with-the-server
I also went through the following article, changed TC/IP settings, restarted, but nothing.
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
Started trying suggestions from comments too but stopped when I realized I might be messing things up more.
So, why is this happening / how can I fix?