SSMS - The semaphore timeout period has expired.

Veena Srinivas 251 Reputation points
2021-03-04T17:59:41.19+00:00

Hello,

I am using SSMS to connect to my sql database in Azure, however I keep getting this error "The semaphore timeout period has expired."

I have even changed the connection time out to 60 seconds.

What else do I do?

Thanks,
Veena

Azure SQL Database
{count} vote

Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2021-03-04T21:02:34.877+00:00

    Do you use a VPN to get connected to your organization? Maybe the issue happens only when you are connected or disconnected from the corporate VPN.

    Please compare the network adapter settings in your computer with network adapters of other computers in your organization. A driver update may have changed settings.

    The issue could also be related to a corporate firewall that may be blocking the traffic. Please try to connect from another network entirely. Make sure port TCP1433 is not blocked. If you are using Windows Firewall make sure you configure it to allow SQL Server access as explained here.

    Open SSMS, make a click on the "Options" button an specify a default database other than the master database. Maybe the login does not have permissions to access the master database.

    Verify network latency in your network.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.