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

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

Answer 1

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.

Answer 2

Maybe you forgot to .Close your connection before.

that's why: Or it could have timed out while attempting to create multiple active connections.

(I cant comment for now due to my reputation, dont take this as a full answer)