Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.

Marcelo Mota Manhães 101 Reputation points
2021-07-27T17:06:32.787+00:00

Hi Team

I´m facing a problem without solution

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=543; handshake=29466; (.Net SqlClient Data Provider)

I tried all steps here
https://support.microsoft.com/en-us/sbs/topic/solving-connectivity-errors-to-sql-server-ae23c94b-b64b-5056-8b62-22e1694bb889?ui=en-US&rs=en-US&ad=US

Without a solution. It says in some part that on previous link that

I Tested, Network, Firewall, SSL (Using open ssl commands) and everything looks good.

I tested for example
Ping
Telnet
Test-NetConnection

Azure SQL Database
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,143 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,241 Reputation points Microsoft Employee
    2021-07-29T17:59:19.373+00:00

    Hi @Marcelo Mota Manhães Thanks for getting back
    This may be due to many reasons. Please check the below steps to make sure you are not missing anything.

    1. Make sure that TCP/IP is enabled as a client protocol on the application server. For more information, see Configure client protocols. On application servers where you don't have SQL tools installed, verify that TCP/IP is enabled by running cliconfg.exe (SQL Server Client Network utility).
    2. Check the application's connection string to make sure it's configured correctly. For example, make sure that the connection string specifies the correct port (1433) and fully qualified server name. See Get connection information. Looks like you checked that already
    3. Test the connectivity between the application server and the Azure SQL Database by using SQL Server management Studio (SSMS), a UDL file, ping, or telnet. For more information, see Troubleshooting connectivity issues and Diagnostics for connectivity issues. (You also did that )

    Please do also check the below document if you are not missing any steps.
    https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues#diagnostics

    If you are still having issues. I will suggest to open a support request so we can get a closer look at your environment to better troubleshoot this.

    Regards,
    Oury

  2. Marcelo Mota Manhaes 1 Reputation point
    2021-07-31T16:51:08.69+00:00

    Thank you Very Much Oury for your inputs, the issue was solved, Basically I did all steps you recommended with success. However the problem was related to internal VPN configuration as I had some missing certificates on TLS handshake process in windows level. After VPN configuration refactory it worked.

  3. Eduardo Baungrates Miolla 0 Reputation points
    2023-09-21T14:18:41.76+00:00

    Olá, eu estou enfrentando esse erro ao tentar conectar o SQL Server no Power B.I

    Detalhes: "Microsoft SQL: 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=22737; handshake=14090; "

    Alguém poderia me ajudar?

    0 comments