I'm trying to connect to my SQL Server Express and I get this error. This happens both locally and on client.
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=216; handshake=7899;
[Login] initialization=0; authentication=0;
[Post-Login] complete=5999; (.Net SqlClient Data Provider)
Can someone help me?
-
The version I use is 2014. I'm trying both using Windows auth or SQL authuser3845038– user38450382015年08月21日 18:19:22 +00:00Commented Aug 21, 2015 at 18:19
-
I am not setting, I'm only with 1 GB.user3845038– user38450382015年08月21日 19:52:53 +00:00Commented Aug 21, 2015 at 19:52
-
1How do you have a version of Windows running on only 1 GB of RAM?Aaron Bertrand– Aaron Bertrand2015年08月22日 12:58:52 +00:00Commented Aug 22, 2015 at 12:58
1 Answer 1
This answer is intentionally Community Wiki to encourage others to edit in other useful links and information for troubleshooting connection problems.
Please try:
Both are Microsoft TechNet guides targeted at your type of problem.
- Aaron Bertrand wrote a blog post listing many different error codes for login related connection errors
The Stack Overflow Q & A Help troubleshooting SqlException: Timeout expired on connection, in a non-load situation provides lot of good pointers to check on a box facing this type of issue.