question

mwinters1 avatar image
mwinters1 asked

Login Timeout Expired

Using SQL 2008 R2 on 64-bit Server 2008 R2 Box. Separate App Server. Randomly (daily) several users receive the following error while in the application: "Logon Failed. Details: ADO Error Code 0x80004005 Source: Microsoft OLE DB Provider for SQL ServerDescription: Login timeout expired SQL State: HYT00" Opinions vary from something misconfigured in SQL to a Network problem. Any ideas/solutions would be appreciated.
logintimeout
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mister Magoo avatar image Mister Magoo commented ·
Have you checked that this is not the result of blocking?
0 Likes 0 ·
mwinters1 avatar image mwinters1 commented ·
Not sure what you mean by blocking.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Generally this is caused by processes running slowly on your SQL Server instance causing things to slow down. It's very difficult to tell you what to do without a lot more information. My best suggestion would be for you to gather more metrics on your server. Look at the wait statistics (sys.dm_os_wait_stats), cpu use, I/O, etc. Understand the load running on your system and attempt to correlate that load to the moments when your errors are occurring.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.