SQL Job failing with Timeout exception

Asked By 200 points N/A Posted on -
qa-featured

 

Hi everyone,

One of my production SQL Job is failing with the message "Timeout expired (SQL State: HYT00 Natice Error: 0)" as shown in image attached.

 
Error connecting to database[
 
Microsoft OLE DB Provider for SQL Server   Timeout expired
 
SQLState: HYT00   Native Error:0 
 
My server's CPU utilization is well below the average. I am not sure if this issue is because of high memory paging or locking.
 
Can anyone suggest the approach to identify the actual cause and probable solutions?
 
Thanks,
Atul.

 

SHARE
Answered By 0 points N/A #127047

SQL Job failing with Timeout exception

qa-featured

In order to solve and avoid the SQL error “Timeout expired (SQL State: HYT00 Natice Error: 0)”, here are the steps that might help you out:

  1. Adding some entry in the host files of the local machine might work out.
  2. Try to check the Net – library protocol that is configured by the “Client Network Utility” in your client network.
  3. Is your client supported by the SQL Server? If you are using Named Pipes, try using TCP/IP.
  4. Sometimes, use the “ping server” to test if the network works.
  5. Also try using “telnet server 1433”, this is to ensure that your SQL Server is listening to the port.

With regards to the timeout, just make sure your network connection is alright.

Related Questions