Azure SQL Database
An Azure relational database service.
5,839 questions
Cannot connect Azure SQL Database to SSMS or Azure Data Studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 46%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
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 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,008 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.
14,149 questions
{count} votes
-
Oury Ba-MSFT 19,886 Reputation points Microsoft Employee2023-10-12T19:41:58.6733333+00:00 Thank you for reaching out.
Could you please check if you have created firewall in the Azure Portal.
Create a server-level firewall rule in Azure portal.
Regards,
Oury
-
Tarek Tamimi 0 Reputation points
2023-10-13T16:29:59.8433333+00:00 Thank you for the response. I removed the firewall rule, but still have the same issue. I also tried having the firewall rule as 0.0.0.0 to allow all Azure services to pass through the server-level firewall rule
-
Oury Ba-MSFT 19,886 Reputation points Microsoft Employee
2023-10-16T19:40:38.3766667+00:00 @Tarek Tamimi Sorry for the late reponse.
Could you please try adding the same IP address next to the "add your client IPv4 Ip address".
Or I would suggest checking with your network admin.
Regards,
Oury
Sign in to comment
2 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 9,901 Reputation points2023-10-16T19:50:47.1333333+00:00 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!
-
Oury Ba-MSFT 19,886 Reputation points Microsoft Employee
2023-10-17T17:50:57.75+00:00 @Anonymous I wanted to check if the above replies were helpful.
Please do share the status of the issue.
Regards,
Oury
Sign in to comment -
