SQL error : 80040E31 timeout

Published by

Posted on July 18, 2008

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Timeout expired

or

Microsoft OLE DB Provider for SQL Server error ‘80040e31’
Timeout expired

solution
As an immediate workaround, force TCP/IP lookup in your connection string and make sure you refer to the SQL Server by IP address

also run the query directly on the sql server and see if the server delays the results.

also check the log file size, if the log is too large it can cause this time out error

Categories: SQL