What are the challenges you face when working across database platforms? Take the survey
Options

Refresh Suggestions not working on SSMS v19 p3

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:

Answers

  • Options
    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 
  • Options
    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
  • Options
    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

  • Options
    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.

  • Options
    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.



  • Options
    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. 
  • Options
    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
  • Options
    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>'.
Sign In or Register to comment.