☰

Active Directory SQL Server 随机握手超时

tag-icon • tag-icon active-directory sql-server
Active Directory SQL Server 随机握手超时

我们在新服务器上安装了 Active Directory，并将数据库服务器和 Web 服务器加入到这个新域中。但是，我们会随机收到以下错误。我们有时会看到握手超时错误，这是什么原因造成的？

事实上，这种情况并不总是发生在我身上，这意味着连接字符串信息可能是正确的（或接近正确）。下面是我们正在使用的连接字符串和我们有时看到的错误：

连接字符串：

Data Source=<IP Address>;Initial Catalog=<DB Name>;Integrated Security=SSPI

堆栈跟踪：

System.Data.SqlClient.SqlException (0x80131904): 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=15610; handshake=0;  ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()

   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()

   at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean& marsCapable)

   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)

答案1

这很可能是由于某些网络问题导致的超时。鉴于这些信息，无法说明网络问题的原因。这可能是客户端和 SQL Server 实例之间的任何原因。客户端或服务器资源问题、有问题的 IP 设置、NIC 错误、网络拥塞或延迟等。我知道这些错误无法可靠地重现，但如果您可以在发生其中一个异常时获得网络跟踪，它可以帮助您指明正确的方向，然后您就可以从那里开始缩小范围。

答案2

步骤1：

netsh trace start capture=yes

步骤 2：在 Microsoft Message Analyzer 中打开

第三步：盈利

相关内容