M$SQL 2005还真的是相当的不稳定
执行一个几乎是默认的操作,结果把SQL Server 2005给搞郁闷了。
在SQL Server 2005上还原AdventureWorks包,按照微软的步骤:http://msdn2.microsoft.com/zh-cn/library/ms160706.aspx。结果第一次执行失败,说什么localhost.AdvWorksDWX数据源打不开还是连不上啥的。跑到数据库里一看已经建好了两个表,一个叫做AdventureWorks另一个叫做AdventureWorksDW。再去看该包的数据源,却分别是localhost.master、localhost.AdvWorksDWX和localhost.AdventureWorks。
再执行了几次,还是不行。于是准备算了,先不捣鼓这个package了,可是没想到让人郁闷的事情还在后头。结果SQL Server 2005居然也连不上了,真是晕死。。。
详细信息是:
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(BooleanenlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectionowningObject, 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(DbConnectionouterConnection, 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()
重启机器后还是不行,不过再多连几次,错误又变成了:
不过稍感欣慰的是,微软给了错误描述的地址,如下:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
但是,这两个连接的内容却是。。。
|
posted on 2006-07-06 21:21 birdshome 阅读(11999) 评论(3) 编辑 收藏 举报