Search code examples
azure-sql-databasehandshake

Azure SQL Server: Error occurred during the pre-login handshake


Occasionally, when I go to connect to my Azure SQL Server through either Power BI or SSMS, I get the following error:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)

There are numerous questions about this topic, but very few address this for Azure SQL Server. My IP address is added to the firewall (and works sometimes!) I have tried increasing the connection time out. I have tried to look at the "netsh WinSock Show Catalog" information as directed by the answer to this question, but nothing looked incorrectly formatted.

Has anyone seen any other reason for this error? It popped up a few days ago, went away for a few days, and is back now, but I haven't changed anything in the meantime.


Solution

  • The problem ended up being that my computer had disconnected from my company's VPN.