How can we help you today? How can we help you today?
Chris_Durante
Activity overview Badges (0) Posts (0) Comments (7)

Activity overview

Latest activity by Chris_Durante

Hi @Jon_Kirkwood - It's working for our Azure SQL and MI instances with AAD + MFA. Thanks! / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10 / SSMS 19.1 / AAD Universal with MFA Azure Managed Instance - No suggestions
Hi @Jon_Kirkwood - It's working for our Azure SQL and MI instances with AAD + MFA. Thanks!
0 votes
ATurner said: This should be fixed in 10.13.13 if you could test and let me know? This should be fixed in 10.13.13 https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.13.2147.exe Confirmed Suggestions now work with AAD auth + MFA and SSMS 19.1, even when Azure SQL or MI is in a different tenant than the user's home tenant. Thanks @ATurner / comments
  1. Community
  2. Redgate forums
  3. SQL Prompt not working when using AAD - Universal with MFA authentication
ATurner said: This should be fixed in 10.13.13 if you could test and let me know? This should be fixed in 10.13.13https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.13.21...
0 votes
Victoria W said: Hi @Stephen77 I'm afraid you've run into a bug. The development team are currently working on it so I'll let you know once we have a fix. Sorry for the inconvenience. @Vic@"Victoria W" Any update on this bug? The product is unusable with our company's cloud governance policies and software configuration solution requiring AAD MFA for Azure SQL and SSMS19 / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10 / SSMS 19.1 / AAD Universal with MFA Azure Managed Instance - No suggestions
Victoria W said: Hi @Stephen77 I'm afraid you've run into a bug. The development team are currently working on it so I'll let you know once we have a fix.Sorry for the inconvenience. @Vic@"Vi...
0 votes
My team continues to have the same issue. It's very similar to an issue we had with the last version and Azure AD authentication with AzureSQL and SQL MI: Suggestions not working with AzureSQL and Azure SQL Managed Instance with AAD and MFA — Redgate forums (red-gate.com) / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10 / SSMS 19.1 / AAD Universal with MFA Azure Managed Instance - No suggestions
My team continues to have the same issue. It's very similar to an issue we had with the last version and Azure AD authentication with AzureSQL and SQL MI:Suggestions not working with AzureSQL and A...
0 votes
sorry for duplicate [image] / comments
  1. Community
  2. Redgate forums
  3. SQL Prompt not working when using AAD - Universal with MFA authentication
sorry for duplicate
0 votes
sorry for duplicate / comments
  1. Community
  2. Redgate forums
  3. SQL Prompt not working when using AAD - Universal with MFA authentication
sorry for duplicate
0 votes
Hi, A related issue we're having seems to be a regression where suggestions aren't loaded when using AAD auth in a secondary tenant - e.g. the Azure SQL server is not in the user's primary tenant. My team members can't use SQL Prompt at all as MFA is required and our identities are in one tenant, while all our Azure SQL servers are in a differnet tenant. See post: Suggestions not working with AzureSQL and Azure SQL Managed Instance with AAD and MFA — Redgate forums (red-gate.com) Here's a log when trying to "refresh suggestions": 2023-05-10 12:19:51.203 -07:00 [Debug] Sending command to server: StoreFullRevision 2023-05-10 12:19:51.204 -07:00 [Verbose] Named pipe created - connecting... 2023-05-10 12:19:51.204 -07:00 [Verbose] Named pipe connected 2023-05-10 12:19:51.207 -07:00 [Verbose] Sending operation json: {"operation":{"type":"StoreFullRevision","message":{"clientIdentifier":"f3ec425c-f11e-491d-a53e-6e43f8d9511b","queryIdentity":"1b3b434e-8646-42f4-a1b6-55d781f6f252","name":"SQLQuery1.sql","path":"C:\\Users\\****\\AppData\\Local\\Temp\\~vsD833.sql","contents":"","connection":null,"saveReason":"QueryEdited"}},"operationType":"command"} 2023-05-10 12:19:51.379 -07:00 [Information] Created new ServerCandidate for server: m*****g.database.windows.net 2023-05-10 12:19:51.388 -07:00 [Debug] Checking is contained or restricted 2023-05-10 12:19:52.292 -07:00 [Warning] Failed to load server m*****g.database.windows.net System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.    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:9e7e332f-3935-4d1c-b172-f2659cda173b Error Number:18456,State:1,Class:14 2023-05-10 12:19:55.319 -07:00 [Debug] AutoRefreshing database m*****d 2023-05-10 12:19:56.062 -07:00 [Debug] An error occurred while auto-refreshing System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.    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.CommonUI.Plugins.AutoRefreshPlugin.AutoRefresh.<Start>b__11_0() ClientConnectionId:daa40988-e963-43d5-9e10-fa76d6663c1e Error Number:18456,State:1,Class:14 2023-05-10 12:19:59.568 -07:00 [Debug] Checking is contained or restricted 2023-05-10 12:20:00.624 -07:00 [Warning] Failed to load server m*****g.database.windows.net 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:b6ee778b-a9d3-42a0-8bab-02e41a85eac8 Error Number:18456,State:235,Class:14 / comments
  1. Community
  2. Redgate forums
  3. SQL Prompt not working when using AAD - Universal with MFA authentication
Hi,A related issue we're having seems to be a regression where suggestions aren't loaded when using AAD auth in a secondary tenant - e.g. the Azure SQL server is not in the user's primary tenant.My...
0 votes
Total activity
9
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2