Connection Timeout Expired. The timeout period elapsed during the post-login phase

.net c# entity-framework sql-server

Question

In my application, queries are working fine. For a single select query, i am getting below error.

System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=13914; [Login] initialization=0; authentication=0; [Post-Login] complete=1062; ---> System.ComponentModel.Win32Exception: The wait operation timed out

I have ran sqlprofiler for detecting deadlocks but found none.

I am running simple query through entity framework

Any help would be appreciated

1
8
9/19/2014 8:27:40 AM

Popular Answer

Here in stack overflow, there is a post called Help troubleshooting SqlException: Timeout expired on connection, in a non-load situation. It is a problem very similar to your problem. Please take a look.

I will quote (from that post) a comment as a possible cause of your problem:

"Not Enough Memory"

"You may have 'Auto Close' enabled"

"SQL Agent Jobs may be causing problems"

In that post you can see a very good explanation about the topic.

3
5/23/2017 12:24:35 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow