Cannot connect Azure SQL Database to SSMS or Azure Data Studio

Tarek Tamimi 0 Reputation points
2023-10-12T15:54:08.5266667+00:00

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 dp300ttamimi.database.windows.net.


ADDITIONAL INFORMATION:

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: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--2-database-engine-error


The wait operation timed out


BUTTONS:

OK


Azure SQL Database
Azure
Azure
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
    2023-10-13T05:19:11.7033333+00:00
    0 comments No comments

  2. Rahul Randive 8,751 Reputation points Microsoft Employee
    2023-10-16T19:50:47.1333333+00:00

    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!