SQL Job failing with Timeout exception

Asked By atulchaturvedi 200 points N/A Posted on - 06/21/2011

  

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.

  

• Status: Open
• Question Views: 1153
• Answer Count: 1
• Vote Up 20 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By shinette 0 points N/A #127047

SQL Job failing with Timeout exception

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.

About shinette

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/10/2011
• Question Category: MS SQL Server