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?
Best Answer
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.