question

Iceblack-7966 avatar image
0 Votes"
Iceblack-7966 asked rianconsulting commented

Azure SQL DB pre-login handshake provider SSL error 0 the wait operation time out. Microsoft SQL Server, Error: 258

Hi

I am getting the following error when I try to connect to some Azure SQL DB, connection from the same machine works without any problem

Any help, please?

TITLE: Connect to Server



Cannot connect to XXXXXXXXXX.database.windows.net.


ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) (Microsoft SQL Server, Error: 258)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=258&LinkId=20476



The wait operation timed out



Thanks

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That link doesn't show the help for the event, it displays the main page.

0 Votes 0 ·

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @Iceblack-7966, welcome to Microsoft Q&A forum.

Can you tell us how are you trying to connect to Azure SQL Database, through SSMS or any other platform? Also please check once if you can connect with other Azure Sql Database and is port 1433 open.

· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AnaragSharma-MSFT

I have tried to connect using SSMS v18.8 and Azure Data Studio on both got the same result against this Azure SQL database, in another hand I can connect to other Azure SQL database without any problem, it's just this Azure SQL Database which cause the error

The options I have selected on SMSS are the followings, I have played with options Encrypt connection and Trust server certificate enabling and disabled, respectly, I have also try to specify the Connect to database with all possible combinations.


64346-image.png


To the other Azure SQL Database that I could connect with SSMS from the same machine, I can connect without any problem checking the box of Encrypt connection or without check that box.

I don't know what else to have a look
I tried the following PS and seems to be ok but it's not
64437-image.png


0 Votes 0 ·
image.png (26.6 KiB)
image.png (13.6 KiB)

I tired using another PS in order to see if I got the same error message,


64388-image.png


0 Votes 0 ·
image.png (89.3 KiB)

Hi @@Iceblack-7966, apologies for the trouble you have been facing.

Would you please confirm if this Azure SQL database was created by you? If not, then there is database level Firewall setting which can be set and could be blocking the access to it. You can contact the Server Admin and check the same by running query against the table 'sys.database_firewall_rules'.

Also are you using the admin credentials to connect to the database or created contained users?




0 Votes 0 ·
Show more comments