SQL Server sa帐户连接超时错误 [英] SQL Server sa account connection timeout error

问题描述

大家好

希望您能帮我解决这个问题已经有好几天了.使用sa帐户通过.NET应用程序向SQL Server数据库执行批量复制后，我无法再使用sa登录.我收到消息连接超时已过或服务器未响应".其他任何凭据也可以使用，因为它们是Windows或SQL Server.

救命!!!!!!!

这就是我得到的

Meout已过期.在操作完成之前超时时间已过，或者服务器没有响应. (.Net SqlClient数据提供程序)

------------------------------
要获得帮助，请单击:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

------------------------------
服务器名称:host \ server1
错误编号:-2
严重性:11
状态:0


------------------------------
程序位置:

在System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常，布尔值breakConnection)
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj，UInt32错误)
在System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult，TdsParserStateObject stateObj)
在System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
在System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
在System.Data.SqlClient.TdsParserStateObject.ReadByte()
在System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj)
在System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
在System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin处(ServerInfo serverInfo，字符串newPassword，布尔值ignoreSniOpenTimeout，Int64 timerExpire，SqlConnection owningObject)
在System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover处(字符串主机，字符串newPassword，布尔型redirectedUserInstance，SqlConnection owningObject，SqlConnectionString connectionOptions，Int64 timerStart)
在System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject，SqlConnectionString connectionOptions，String newPassword，Boolean redirectedUserInstance)
在System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity身份，SqlConnectionString connectionOptions，对象providerInfo，字符串newPassword，SqlConnection owningObject，布尔型redirectedUserInstance)
在System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions选项，对象poolGroupProviderInfo，DbConnectionPool池，DbConnection owningConnection)
在System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection，DbConnectionPoolGroup poolGroup)
在System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
在System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection externalConnection，DbConnectionFactory connectionFactory)
在System.Data.SqlClient.SqlConnection.Open()
在Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci，IServerType服务器)
在Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()< b></b>

Hi Guys

Hope you can help me on this one have been at it for days. After using carrying out a bulk copy with a .NET application to a sql server database using the sa account I can no longer login using sa. I am getting the message Connection timeout elapsed or the server is not responding". Any other other credentials work be they windows o r sql server.

Help !!!!!!!

here is what i get

meout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

------------------------------
Server Name: host\server1
Error Number: -2
Severity: 11
State: 0


------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()<b></b>

推荐答案

Hello

http://vyaskn.tripod.com/watch_your_timeouts.htm [

Hello

http://vyaskn.tripod.com/watch_your_timeouts.htm[^]


Check this out

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