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

Iceblack 1

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

Rian 1 Reputation point

2021-08-22T14:34:57.793+00:00

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

1 answer

Anurag Sharma 17,591 Reputation points

2021-02-05T05:45:47.047+00:00

Hi @Iceblack , 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.
Please sign in to rate this answer.
Iceblack 1 Reputation point

2021-02-05T07:17:29.173+00:00

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.

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

Iceblack 1 Reputation point

2021-02-05T07:23:57.763+00:00

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

Anurag Sharma 17,591 Reputation points

2021-02-09T06:05:15.953+00:00

Hi @@Iceblack , 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?

Iceblack 1 Reputation point

2021-02-10T17:58:57.107+00:00

Hi @AnuragSharma-MSFT ,

No worries, you are trying to help, so thank you very much.

The Azure SQL database was created by pipeline in DevOps using terraform.

The database firewall has in the whitelist the public ip address that I am getting out on internet, if there was a problem with firewall I guess with SSMS 18.8 it will pop up a message saying that a new firewall rules has to be put in place and I had to log into the portal to put the new firewall rule in place.

Yes, the account used to connect has admin permissions, it's not just a contained user where it has to point to the db on the connection.

Do you have deeper information regarding pre-handshake Error: 258 that you can share?

Thanks and regards

Anurag Sharma 17,591 Reputation points

2021-02-11T05:08:43.823+00:00

Thanks for reverting back. There could be multiple reasons behind this like if the server is stopping, or the firewall is not configured properly or mostly could be the connectivity issue with this specific server.

I would suggest to raise a support ticket if you have a support plan and an MS engineer could directly look into this specific service. If you face any issue with respect to creating support ticket, please let us know.

Iceblack 1 Reputation point

2021-02-12T19:59:02.853+00:00

Hi @AnuragSharma-MSFT

Thanks, I will do that.
Sign in to comment