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

Comments

Sort by recent activity
Installing the latest version has resolved the issue. Thanks. / comments
  1. Community
  2. SQL Prompt
  3. Add square brackets not working
Installing the latest version has resolved the issue. Thanks.
0 votes
I am experiencing the same issue,Windows 11, SSMS 19 Preview 2 running SQL Prompt 10.12.1.28146 using MFA. The log shows the following when trying to authenticate: 2022-06-28 08:56:13.669 +01:00 [Warning] Failed to load server {Removed} System.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'. The server is not currently configured to accept this token.    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:{Removed} Error Number:18456,State:235,Class:14 / comments
  1. Community
  2. SQL Prompt
  3. Support for Azure SQL Database
I am experiencing the same issue,Windows 11, SSMS 19 Preview 2 running SQL Prompt 10.12.1.28146 using MFA. The log shows the following when trying to authenticate: 2022-06-28 08:56:13.669 +01:00 [...
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2