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.
I also went through the following article, changed TC/IP settings, restarted, but nothing.
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?
netstat -ao
and confirm that port 1433 is listening and that the PID belongs to sqlservr.exe. If it is listening, check that TCP/IP is enabled for the IP address that you're actually connecting to in SQL Server Configuration Manager (as Max has shown, but also open up the properties of TCP/IP and ensure that the correct IP is enabled).