SQL SERVER AGENT ISSUE

Rohit Kulkarni 676 Reputation points
2022-04-27T16:17:08.8+00:00

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

Regards
RK

SQL Server on Azure Virtual Machines
Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,806 Reputation points MVP
    2022-04-28T03:20:59.247+00:00

    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