Connection timed out. Waiting period elapsed during the post-entry phase

Question

In my application, queries work fine. For one select request, I get below error.

Fix System.Data.EntityException: The underlying provider does not work in Open. ---> System.Data.SqlClient.SqlException: connection timed out. The waiting period expires during the phase after entry. the connection can be disconnected while waiting for the server to complete the registration and response process; Or he might be trying to create some active connections. The duration when trying to connect to this server was [Pre-Login] initialization = 0; acknowledgment = 13914; [Login] initialization = 0; Authentication = 0; [Post-Login] complete = 1062; ---> System.ComponentModel.Win32Exception: timeout

I ran sqlprofiler to detect deadlocks but could not find.

I run a simple query through the framework entity

Any help would be appreciated

Answer 1

Here, in the stack overflow, there is a message called SqlException troubleshooting help: the timeout expired when connecting in a no-load situation . This is a problem very similar to your problem. Please take a look.

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

"Out of memory"

"You may have turned on Auto Close

"SQL Agent Jobs May Cause Problems"

In this post you can see a very good explanation of this topic.

Answer 2

You may have forgotten. Close your connection earlier.

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

(I cannot answer this question because of my reputation, do not take this as a complete answer)