Cannot connect Azure SQL Database to SSMS or Azure Data Studio

Tarek Tamimi 0 Reputation points

Getting the error message below every time I attempt to connect my Azure SQL Database to SSMS or Azure Data Studio. I am working off my corporate laptop, so not sure if it is a firewall/network issue.

TITLE: Connect to Server

Cannot connect to


Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=414; handshake=29590; (Microsoft SQL Server, Error: -2)

For help, click:

The wait operation timed out



Azure SQL Database
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,017 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 41,411 Reputation points
    0 comments No comments

  2. Rahul Randive 8,751 Reputation points Microsoft Employee

    Hi @Tarek Tamimi

    Please run the SQL Connectivity checker

    The SQL Connectivity checker is a PowerShell script that automates a series of checks for the most common configuration issues. Most issues it detects come with recommended solutions.

    Copy the PowerShell script to run the Checker Tool on the client computers where the error is occurring.

    Provide the server, database, admin user and password in the script and execute.

    Once the checker is executed, it will generate an output file on your local machine, which will contain the root cause of the connectivity issue.

    Thank you!