如何解决SQL2000中的此错误 [英] How to solve this error in sql2000

问题描述

当我尝试使用以下连接字符串将sql2000从PC(使用拨号网络连接)连接到数据库服务器时，出现以下错误:

I got the following error when I tried to connect sql2000 from my PC (using Dial-up net connection) to the database server using this connection string:

ConnectionString = "Data Source=XXX.XX.XX.XX;Integrated Security=SSPI;Initial Catalog=db_accounting_system; User ID=sa ;Password=***"

Unable to open database. Connection string: 'Data Source=XXX.XX.XX.XX;Integrated Security=SSPI;Initial Catalog=db_accounting_system; User ID=sa ;Password=1***'; Error: 'System.Data.SqlClient.SqlException: 
A connection was successfully established with the server, but then an error occurred during the login process. 
(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
   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 DevExpress.Xpo.B.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)'

我正在使用VS2010，SQL2000和devexpress.xpo.v6.3.

I''m using VS2010, SQL2000 and devexpress.xpo.v6.3.

推荐答案

将Integrated Security设置为true(SSPI = true)时，UID和密码不使用，而是使用当前的Windows登录帐户.

http://msdn.microsoft.com /en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=VS.100).aspx [

When Integrated Security is set to true (SSPI = true) the UID and Password are not used, instead the current Windows Login account will be used.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=VS.100).aspx[^]

这篇关于如何解决SQL2000中的此错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！