Azure SQL Database
An Azure relational database service.
5,925 questions
Hi Oury, yes I have solved this issue by allowing access to the server. Thank you!
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
![](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(182.40000000000003, 45%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jonpier Veliz
0
Reputation points
I am trying to connect to a Azure SQL database in Server Management Studio, but I get a timeout period error. I have tried increasing the connection time out and enabling "trust server certificate". I noticed that my connection string has this: "TrustServerCertificate=False;Connection Timeout=30;" Is there a way I can edit this so that it is set to True? Or are there other things I could try?
{count} votes
-
GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee2023-04-04T19:17:33.4066667+00:00 @Jonpier Veliz Welcome to the Microsoft Q&A platform, thanks for posting the question Can you please try changing the Connection policy to Default in Firewalls and virtual networks settings for your Azure SQL server.
Regards Geetha
-
Jonpier Veliz 0 Reputation points
2023-04-04T19:43:29.78+00:00 I have created a Firewall rule with my computer IP, but I do not have a virtual network. Is it necessary that I have one?
-
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee2023-04-10T18:34:19.47+00:00 Jonpier Veliz Could you please share the version of SSMS you are using.? Regards, Oury
-
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
2023-04-10T18:49:54.6066667+00:00 Jonpier Veliz Could you please the full error message. For how to set SSMS options
The general problem when connections fail with a timeout is that the client doesn’t have network access to the server. Run through the troubleshooting steps listed here: https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki/0000-Troubleshooting-Workflows Regards, Oury
-
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
2023-04-12T23:21:29.5166667+00:00 Jonpier Veliz We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. Regards, Oury
-
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
2023-04-27T20:43:44.7166667+00:00 -
![](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(153.6, 9%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Venkata Chintala 0 Reputation points2024-06-21T07:52:51.3233333+00:00 Hi ,I also have the same issue connecting from Data studio to Azure SQL DB.
I have also added my IP in the firewall, still not able to connect. Please suggest.
-
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
2024-06-24T20:51:16.55+00:00 What error message are you getting?
Sign in to comment
1 answer
Sort by: Most helpful
-
Jonpier Veliz 0 Reputation points
2023-04-25T14:10:45.7533333+00:00 -
![](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(51.2, 64%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
mahamood ali 0 Reputation points2023-07-10T14:59:52.7+00:00 how you gave access to sever
Iam trying to connect SQL server using android emulator.
Sign in to comment -