User profile for haydn75

Hi I've updated to SSMS 19.0.2 and SQl Prompt 10.13.7.360 and still getting the same issue when using MFA Authentication on an Azure DB from the RedGate Verbose Logs: 2023-05-11 15:05:31.344 +08:00 [Verbose] Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 2 HTTP status code = 200 OK Response body = 2023-05-11 15:07:28.056 +08:00 [Debug] Sending command to server: StoreFullRevision 2023-05-11 15:07:28.057 +08:00 [Verbose] Named pipe created - connecting... 2023-05-11 15:07:28.057 +08:00 [Verbose] Named pipe connected 2023-05-11 15:07:28.060 +08:00 [Verbose] Sending operation json: {"operation":{"type":"StoreFullRevision","message":{"clientIdentifier":"9632d5b6-186d-45cc-86aa-1ea440f1e5ae","queryIdentity":"7fb1bdf6-9482-4be0-a0cb-1ca4f1de1de7","name":"SQLQuery1.sql","path":"C:\\Users\\hflower\\AppData\\Local\\Temp\\~vsF380.sql","contents":"","connection":null,"saveReason":"QueryEdited"}},"operationType":"command"} 2023-05-11 15:07:28.491 +08:00 [Information] Created new ServerCandidate for server: solv-azmh-db-01.database.windows.net 2023-05-11 15:07:28.499 +08:00 [Debug] Checking is contained or restricted 2023-05-11 15:07:28.804 +08:00 [Warning] Failed to load server solv-azmh-db-01.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:d5a6155d-7548-4778-87da-b946ccc1c756 Error Number:18456,State:1,Class:14 / comments

Hi I've updated to SSMS 19.0.2 and SQl Prompt 10.13.7.360and still getting the same issue when using MFA Authentication on an Azure DB from the RedGate Verbose Logs:2023-05-11 15:05:31.344 +08:00 [...

0 votes

this is a fresh install on SSM v19 (the latest new release) I'm not sure if SQL Prompt ever worked with MFA in this version. It worked on SSMS v18 / comments

this is a fresh install on SSM v19 (the latest new release) I'm not sure if SQL Prompt ever worked with MFA in this version.It worked on SSMS v18

0 votes

Thanks Victoria, I used this url https://documentation.red-gate.com/sp/troubleshooting/finding-the-sql-prompt-log-files and used Verbose to find the problem with the Snippets / comments

Thanks Victoria,I used this url https://documentation.red-gate.com/sp/troubleshooting/finding-the-sql-prompt-log-filesand used Verbose to find the problem with the Snippets

0 votes

if I turn the "enable Suggestions" off then the error doesn't happen, but what's the point in using SQL Prompt if I don't have the Intellisense/Code Completion working? / comments

if I turn the "enable Suggestions" off then the error doesn't happen, but what's the point in using SQL Prompt if I don't have the Intellisense/Code Completion working?

0 votes

How can we help you today?

haydn75

Comments