2008 R2尝试连接到此服务器所花费的时间是 - [Pre-Login] initialization = 1;握手= 14999; [英] 2008 R2 The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=14999;

问题描述

我们间歇性地收到以下错误。  这种情况很少见，但幅度足以触发我们的错误监控系统发出的警报。  它们持续约30秒并消散。  它们似乎在SQL Server或尝试实例化连接的Application Server上没有任何其他
主要流量或资源消耗变化的情况下发生。    它们会偶尔（但并非总是）与SQL Server上的spid重用错误一起抛出。

我们正在使用ADO.NET来创建连接。  

 连接 超时  已过期。   超时 期间 已过去 而 尝试   消耗   < span class ="x_x_t">  pre   -   login   握手  确认。 此 可以   因为     pre   -  登录  握手 失败 或   服务器   无法   回复 < span class ="x_x_t"> back     时间。   持续时间 花费 而 尝试    connect    此 服务器     -   [ 前  -  登录 ]  初始化 =  1  ;  握手 =  14999  ; 

SQL构建：  10.50.2796.0

。NET版本：  .NET Framework 4.5

感谢任何帮助。

< hr>

dweh01

解决方案

检查以下链接，似乎类似问题：

http://stackoverflow.com/questions/15488922/connection-to-sql -server-作品-有时

We are intermittently receiving the following error.  This is very infrequent but the magnitude is enough to trigger alerts from our error monitoring system.  They last about 30 seconds and dissipate.  They seem to happen without any other major changes in traffic or resource consumption on the SQL Server or the Application Server that is attempting to instantiate the connection.    They do occasionally, but not always, get thrown in conjunctions with spid reuse errors on the SQL Server.

We are using ADO.NET to create the connections.  

Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=14999;

SQL build: 10.50.2796.0

.NET version: .NET Framework 4.5

Any help is appreciated.

---

dweh01

解决方案

Check below link, seems similar issue:

http://stackoverflow.com/questions/15488922/connection-to-sql-server-works-sometimes

这篇关于2008 R2尝试连接到此服务器所花费的时间是 - [Pre-Login] initialization = 1;握手= 14999;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！