How can we help you today? How can we help you today?

Eeek! Tried it on another PC. Installed OK, then Crashed

Thought I'd try it on another PC. Win2K SQL2K client stuff etc. No known problems. This time it installed. Cranked up Enterprise Manager, Selected server and database, clicked on Tools query analyser. Query analyser showed the menu item, and the message box fine, then Kapow. Error window. (Query analyser works fine without SQL Prompt. definitely logged into server etc)

"System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
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 RedGate.SqlPrompt.Engine.ConnectionProperties.RetrieveServerDetails()
at _18.Refresh(IAuthenticationTokenProvider provider)
at _18._1(IAuthenticationTokenProvider )
at _18.GetMetaData(IAuthenticationTokenProvider provider)
at RedGate.SqlPrompt.Engine.Cache.MetaDataCache._1(_18 , _4 , IAuthenticationTokenProvider , Boolean )
at RedGate.SqlPrompt.Engine.Cache.MetaDataCache.GetDatabase(ConnectionProperties conn, IAuthenticationTokenProvider provider, Boolean bleatIfBlacklisted)
at RedGate.SqlPrompt.Engine.Cache.MetaDataCache.GetDatabase(ConnectionProperties conn, IAuthenticationTokenProvider provider)
at RedGate.SQLPrompt.CommonUI.TaskExecuter.LoadDatabaseTask.DoTask()
at RedGate.SQLPrompt.CommonUI.TaskExecuter.TaskExecuter.ExecuteTask()
"
AndrewRMClarke
0

Comments

2 comments

Sort by
  • Lionel
    Thanks for the feeback. We will need to add some code to more gracefully handle connection timeouts.

    Lionel
    Lionel
    0
  • AndrewRMClarke
    Well, it did look a bit like the southern Lebanon after it happened, but there was no reason for a timeout, as the Query Analyser was connecting with no issues. It connects once SQL Prompt is uninstalled! It happens on just one of the PCs which is completely patched up. etc.
    AndrewRMClarke
    0

Add comment

Please sign in to leave a comment.