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

Activity overview

Latest activity by spd

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
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
Add square brackets not working
  1. Community
  2. SQL Prompt
SQL Prompt Version 10.6.2.18034SQL Server Management Studio 15.0.18330.0SQL Server Management Objects (SMO) 16.100.37971.0Microsoft Analysis Services Client Tools 15.0.19040.0Microso...
2 followers 2 comments 0 votes
Bug with brackets on identifiers - STRING_SPLIT
  1. Community
  2. SQL Prompt
When formatting a script that contains STRING_SPLIT with the option "Add/remove square brackets" set to "Add brackets to all identifiers", the first unbracketed instance of STRING_SPLIT gets bracke...
0 followers 0 comments 0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2