Rohit Kulkarni 676 Reputation points

Hello Team,

For one of the Job It is getting refreshed every 1 hr. But today we are facing some issue in the Job while running randomly it is getting failed and getting error :

The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

Example : 9 am : Success
10 am : Failed
11 am : Failed
12 Noon : Success
1 pm : Success
2 pm : Success


SQL Server on Azure Virtual Machines
Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 27,786 Reputation points MVP

    Please disable DHE Cyphers as explained here.

    Please try to add following applications to the Windows Firewall: sqlbrowser.exe and sqlservr.exe. Grant them domain and private network traffic. Here you will find a guide on how to configure Windows Firewall for SQL Server access.

    Here are other possible causes of this error and ways to solve them.

    0 comments No comments