Anyone else have suggestions not working in latest update of SQL Prompt?

av99

I upgraded a couple of days ago to SQL Prompt 10.14.5.5385 and now suggestions don't work anymore. I have disabled suggestions, re-enabled it, run ctrl-shift-R, closed SSMS and re-open it. closed all windows, start fresh and no suggestions come up. 

I am using SSMS v18.12.1

AlanGraham

Just restarted and updated to 19.3 and Prompt 10.14.5.5385. My local servers (2008R2) are working fine. The Azure Managed Instance ones no suggestions at all.

Ben_P

Hi @AlanGraham,

Thank you for your post. 

Which authentication method are you using when connecting to the MI in SSMS? 

AlanGraham

@Ben_P

I'm using Entra (AAD) auth for the MI. I downgraded to SQL prompt 10.14.4.4865 and that version works still. 

Davidian

You're not the only one, all our PaaS connections do not work in the latest version though our IaaS connections do - but our IaaS connections use windows auth and our PaaS use Microsoft Entra MFA 

JPSpivey_AmWins

I was having similar issues.  Azure Synapse PDW.  Downgraded to 10.14.4.4865 per AlanGraham's suggestion.  Working as it should now.

Davidian

Just to confirm - the latest 2 editions for SQL prompt do not work, the downgrade to SQL prompt 10.14.4.4865 gets things working again though. 

KimCSOKI

This was very helpful and downgrading to version 10.14.4.4865 finally got me working.

Kreism

How are you guys finding 10.14.4.4865?  When I attempt to download a specific version all I have to choose from is a dropdown with 6-7 version (none of which are 10.x).

Nevermind, just found it:  https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-14-release-notes

KimCSOKI

I googled the version to see if I could find it.  I didn't, but found a different one and then just changed the numbers to the version I wanted.  I ultimately downgraded again because SSMS was locking up with the 10.14.4 version above.  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.3.4664.exe

badpeeg

I think that's what I will have to do as well. Thanks for the link.

Ben_P

Hi all, for those of you with this issue when connecting to your servers, are you all using Entra ID with MFA? We have had other reports of such behaviour from other users and this issue has been raised with the development team who are investigating. 

Davidian

Hey Ben, 

I think it is also the AAD (Azure active directory - Integrated) version

Kreism

Ben_P said:

Hi all, for those of you with this issue when connecting to your servers, are you all using Entra ID with MFA? We have had other reports of such behaviour from other users and this issue has been raised with the development team who are investigating. 

Yes, I am using Entra ID with MFA and having this issue.

badpeeg

For me, the problem is happening across all of my authentication methods (Entra ID with FFA and database logins).

Ben_P

The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SSMS, such as 19.2 or 18.12.1. Users have also reported that downgrading SQL Prompt to 10.4.4 has worked for them:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe