How can we help you today? How can we help you today?

SQL Prompt not working

We're using latest version of SQL Prompt, and all of our developers are facing an issue where the suggestion window does not show the column names as shown in the screenshot

This is not isolated, its all users, in all machines, physical laptops, VM's etc...

Using Azure database
Faizul_Hussain
0

Comments

20 comments

Sort by
  • DanC
    Hi @Faizul_Hussain

    Can I ask are you using an Azure Managed Instance authentication using Entra MFA (Azure AD MFA)?
    DanC
    0
  • Faizul_Hussain
    Hi @DanC,

    Yes we are using Entra with MFA

    Thanks
    Faizul_Hussain
    0
  • DanC
    Hi @Faizul_Hussain

    This is currently a known issue with Azure Managed Instances and using Entra with MFA

    Could you downgrade to using this version here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.6.5992.exe

    Then also use SSMS versions 18.12.1 or 19.2
    DanC
    0
  • Faizul_Hussain
    Hi @DanC,

    This issue happens even with local instance of SQL Server, not just Azure Managed instances

    I have tried SSMS 19.2 and SQLPrompt_10.14.6.5992.exe

    Thanks
    Faizul_Hussain
    0
  • Faizul_Hussain
    I have tried SSMS 19.2 and SQLPrompt_10.14.6.5992.exe
    Faizul_Hussain
    0
  • DanC
    Hi @Faizul_Hussain

    We had a release today which should address the issue when on the latest version of SSMS: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe
    DanC
    0
  • Faizul_Hussain
    Same issue unfortunately :(
    Faizul_Hussain
    0
  • DanC
    Hi @Faizul_Hussain

    I'm going to reach out via a support ticket to investigate this further with you
    DanC
    0
  • JoelAPatton
    I am running into this same issue.  Logs show the following error:

    Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'.
       at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at Microsoft.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover, Boolean isFirstTransparentAttempt, Boolean disableTnir)
       at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
       at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
       at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, ServerCertificateValidationCallback serverCallback, ClientCertificateRetrievalCallback clientCallback, DbConnectionPool pool, String accessToken, SqlClientOriginalNetworkAddressInfo originalNetworkAddressInfo, Boolean applyTransientFaultHandling)
       at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
       at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
       at Microsoft.Data.SqlClient.SqlConnection.Open()
       at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()

    This only occurs when logged in via Entra MFA

    SSMS Version: 19.3.4.0
    SQL Prompt: 10.14.10.7538
    JoelAPatton
    0
  • DougY
    DanC said:
    Hi @Faizul_Hussain

    I'm going to reach out via a support ticket to investigate this further with you
    Is there a resolution or an upcoming resolution for this?  SQL Prompt stopped popping up the IntelliSense and the auto complete which defeat one of its main features.  Trying to downgrade, the closest version available is V9.5, unless I am missing something on the download page.

    SQL Prompt -- 10.14.10.7538
    SSMS -- 18.12.1

    Thanks,

    DougY
    0
  • Sparx
    I have the exact same issue and have tried reinstalling multiple times with no success. Has anyone found a solution? Found that any updates have worked?
    Sparx
    0
  • DanC
    Hi @Sparx

    Unfortunately, this is still currently a bug in the tool

    I would advise reaching out with a support ticket to keep updated
    DanC
    0
  • DougY
    Checking the 'Trust server certificate' when connecting to the server resolved the issue for me.





    DougY
    0
  • Sparx
    DougY said:
    Checking the 'Trust server certificate' when connecting to the server resolved the issue for me.





    Wow, yeah I tried everything including the checkbox above. I uninstalled and reinstalled everything at least a couple times. Finally, I thought maybe it was still something to do with the connection I had setup to my server. I looked up how to delete it and you just choose the dropdown for the connection and hit the delete button. I re-entered my server and credentials, checked the boxes as Doug has above, and things worked again. For my issue it had something to do with my connection setup even beyond just check the box that must've been messed up, so I'd suggest just deleting it and redo the connection as new while ensure the Trust Server Certificate box is checked. Might not fix everything but it's a small thing to do that fixed my issue after trying everything else.
    Sparx
    0
  • markecyu
    None of the above worked for me either. Azure MFA connection generates in logs:
    SqlException (0x80131904): Login failed for user '<token-identified principal>'.
    markecyu
    0
  • gigabyte77
    I am experiencing the same issue connecting to an Azure SQL Managed Instance (authenticated with Microsoft Entra MFA) with SQL Prompt 10.14.18.8999.  I have tried with both SSMS 19.3 and 20.1.

    I have tried checking Trust Server Certificate and the error still exists.
    gigabyte77
    0
  • sullyc
    Same issue here connecting to an Azure SQL Managed Instance (authenticated with Microsoft Entra MFA) with SSMS 20.1 & SQL Prompt 10.14.19.89311
    sullyc
    0
  • gigabyte77
    FYI, I received this message from support:  

    Can you uninstall SQL Prompt, then reinstall using the installer below?
    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe

    This version does allow SQL Prompt to work properly in SSMS 19.3.  I was unable to get it to install for SSMS 20.1.
    gigabyte77
    0
  • gigabyte77
    I also got this from support when I asked when the latest version of SQL Prompt would work:

    The issue is caused by conflicting MDS versions between SSMS and SQL Prompt. It's currently under investigation with the developers.
     
    As of now, you will have to continue using 10.14.4 if you wish to use Azure Managed Instances +  MFA authentication.
    gigabyte77
    0
  • patubo
    I currently have SSMS v20.2 and SQL prompt v10.14.21.9884 installed. Could you advise which latest combination address the prompt suggestion issues please? 
    I'm seeing the same issue on azure MFA
    patubo
    0

Add comment

Please sign in to leave a comment.