2

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?

  • What version of SQL Server Express? Are you trying to connect with an application, Management Studio (what version), or something else? Are you using Windows auth or SQL auth? Is your login a member of sysadmin? Is there a logon trigger in place? Are you using AttachDbFileName? – Aaron Bertrand Aug 21 '15 at 18:02
  • The version I use is 2014. I'm trying both using Windows auth or SQL auth – user3845038 Aug 21 '15 at 18:19
  • @AaronBertrand I think my problem may be a lack of memory. – user3845038 Aug 21 '15 at 19:38
  • How much memory do you have? Have you adjusted max server memory? – Aaron Bertrand Aug 21 '15 at 19:51
  • 1
    How do you have a version of Windows running on only 1 GB of RAM? – Aaron Bertrand Aug 22 '15 at 12:58
4

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.

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.