连接超时错误 [英] Connection timeout Error

问题描述

对于在Visual Studio 2010中构建的exe的sql server 2008 r2，我有时会遇到计划任务的连接超时错误。当我手动单击任务计划运行按钮时，它每次都正常工作。这是经常记录的错误日志，而不是所有时间。任何人都可以在此建议可能发生的事情以及如何解决它？



用户'sa'登录失败。无法连接SQL Server

连接超时已过期。在登录后阶段过去了超时时间。在等待服务器完成登录过程并响应时，连接可能已超时;或者在尝试创建多个活动连接时可能会超时。尝试连接到此服务器所花费的时间是 - [Pre-Login] initialization = 4;握手= 7; [登录]初始化= 0;认证= 0; [登录后]完成= 14001;

Hi,

I am getting a connection timeout error for a scheduled task for sometimes in sql server 2008 r2 for an exe which was build in Visual Studio 2010. When I click the task schedular run button manually, it works fine everytime. Here is the error log that was getting recorded frequently and not all the times. Can any one suggest on this what could be happening and how to resolve it?

Login failed for user 'sa'.SQL Server could not be connected
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=4; handshake=7; [Login] initialization=0; authentication=0; [Post-Login] complete=14001;

推荐答案

在Stack Exchange上查看此问题。这可能正是您的问题所在。但它可以帮助。我有同样的问题，这给了我们帮助。



http://stackoverflow.com/questions/1421978/help-troubleshooting-sqlexception-timeout-expired-on-connection-in-a-non-load [ ^ ]

See this Question on Stack Exchange. This may be exactly your problem. But it can be help. I had same problem and This gave the help.

http://stackoverflow.com/questions/1421978/help-troubleshooting-sqlexception-timeout-expired-on-connection-in-a-non-load[^]

这篇关于连接超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！