How can we help you today? How can we help you today?
mschumacher
Activity overview Badges (0) Posts (0) Comments (2)

Comments

Sort by recent activity
Extended Event Session was great.. didn't know those exited.. lots of opportunity there / comments
  1. Community
  2. General Forum
  3. Redgate Streamed - Virtual Booth Competition
Extended Event Session was great.. didn't know those exited.. lots of opportunity there
0 votes
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
  1. Community
  2. SQL Prompt
  3. SQL Prompt 9.0.2.3223 - Azure SQL - Failed To Load
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
Total activity
4
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2