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

Activity overview

Latest activity by mschumacher

still seems to be a problem on 9.5.13.11024 - SSMS 18.1  Any work arounds known to work to get suggestions to work ? 20 Aug 2019 16:25:10,881 [9] WARN  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Failed to load server xxxxxxxx.database.windows.net System.Data.SqlClient.SqlException (0x80131904): Cannot open server "xxxxxx.com" requested by the login.  The login failed.    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)    at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)    at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)    at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)    at System.Data.SqlClient.SqlConnection.Open()    at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.IsContainedOrRestrictedDatabase(ConnectionProperties cp)    at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadDatabaseContainment()    at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer() ClientConnectionId:09bcfc64-c46a-41f7-af23-c393fd48f2bc Error Number:40532,State:1,Class:20 / comments
still seems to be a problem on 9.5.13.11024 - SSMS 18.1 Any work arounds known to work to get suggestions to work ?20 Aug 2019 16:25:10,881 [9] WARN  RedGate.SqlPrompt.Cache.Candidates.ServerCandid...
0 votes