Refresh Suggestions not working on SSMS v19 p3

haydn75haydn75 Posts: 6 New member
in SQL Prompt
When I use Azure Active Directory - Universal MFA Authentication with SQL Prompt 10.13.0.31319 it can't retrieve the Table/Field Meta data when I Refresh the Suggestions Ctrl + Shift + D

if I use SQL Authentication it does work however
Tagged:
· Share on Twitter

Answers

  • DustinMDustinM Posts: 66 Bronze 1
    Hello, 

    Thank you for your inquiry into SQL Prompt, we are sorry to hear that it is giving you trouble.

    The issue with refreshing suggestions did this start after updating to SQL Prompt v10.13.0 and worked fine on a previous version or is this a new install and refresh suggestions never worked with MFA?

    Best,

    Dustin 
    · Share on Twitter
  • haydn75haydn75 Posts: 6 New member
    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
    · Share on Twitter
  • haydn75haydn75 Posts: 6 New member
    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

    · Share on Twitter
  • AashiAashi Posts: 2 New member
    DustinM said:
    Hello, 

    Thank you for your inquiry into SQL Prompt, we are sorry to hear that it is giving you trouble.

    The issue with refreshing suggestions did this start after updating to SQL Prompt v10.13.0 and worked fine on a previous version or is this a new install and refresh suggestions never worked with MFA?

    Best,

    Dustin 

    Hi friend
    I appreciate you using SQL Prompt to solve the problem. It's critical to establish whether the issue first appeared after updating to v10.13.0 or whether it has existed previously.

    · Share on Twitter
  • AashiAashi Posts: 2 New member
    haydn75 said:
    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

    Hi friend

    Thank you for providing the details. It seems that SQL Prompt's compatibility with MFA might be an issue in the latest SSMS v19 release. It's worth investigating further or reaching out to support for clarification and potential solutions.



    · Share on Twitter
  • ATurnerATurner Posts: 204 Silver 2
    Hi All

    The development team is aware of an issue and is looking into it. You should see an extra authentication prompt when selecting in the query that if you continue through should allow the code completion to work. 
    · Share on Twitter
  • Karsten_2023Karsten_2023 Posts: 1 New member
    edited November 28, 2023 4:43PM
    Hi,

    I'm running into the same issue on
    SQL Server Management Studio                        19.2.56.2
    SQL Prompt                                                        10.14.2.4417
    Both freshly installed. Is there a schedule when it will be fixed?

    Regards
    Karsten
    · Share on Twitter
  • BillyBlankenshipBillyBlankenship Posts: 1 New member
    I am also running into same issue as Karsten_2023.  Same install versions and getting the below error in the logs:

    Error Number:18456,State:1,Class:14
    2024-01-08 09:10:38.910 -06:00 [Warning] Failed to load server tcp:someServer.database.windows.net, somePort
    Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'.
    · Share on Twitter
Sign In or Register to comment.