N/APosted on - 06/21/2011
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?
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:
Adding some entry in the host files of the local machine might work out.
Try to check the Net – library protocol that is configured by the “Client Network Utility” in your client network.
Is your client supported by the SQL Server? If you are using Named Pipes, try using TCP/IP.
Sometimes, use the “ping server” to test if the network works.
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.