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

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

av99av99 Posts: 8 Bronze 3
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


Tagged:

Answers

  • Options
    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.
  • Options
    Hi @AlanGraham,

    Thank you for your post. 

    Which authentication method are you using when connecting to the MI in SSMS? 
  • Options
    @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. 
  • Options
    DavidianDavidian Posts: 11 New member
    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 
  • Options
    I was having similar issues.  Azure Synapse PDW.  Downgraded to 10.14.4.4865 per AlanGraham's suggestion.  Working as it should now.
  • Options
    DavidianDavidian Posts: 11 New member
    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. 
  • Options
    KimCSOKIKimCSOKI Posts: 3 New member
    This was very helpful and downgrading to version 10.14.4.4865 finally got me working.
  • Options
    KreismKreism Posts: 2 New member
    edited February 5, 2024 3:17PM
    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
  • Options
    KimCSOKIKimCSOKI Posts: 3 New member
    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
  • Options
    badpeegbadpeeg Posts: 2 New member
    I think that's what I will have to do as well. Thanks for the link.
  • Options
    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. 
  • Options
    DavidianDavidian Posts: 11 New member
    Hey Ben, 

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


  • Options
    KreismKreism Posts: 2 New member
    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.
  • Options
    badpeegbadpeeg Posts: 2 New member
    For me, the problem is happening across all of my authentication methods (Entra ID with FFA and database logins).
  • Options
    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


  • Options
    Has there been any progress on this? We are still experiencing this issue using SQL Prompt 10.14 and SSMS 20.1.
  • Options
    RobPieRobPie Posts: 1 New member
    edited June 27, 2024 11:01AM
    I am still having this same issue. I'm currently using SSMS 20.1 with SQL Prompt: 10.14.20.9646.

    *Update 6/26: I just updated to 10.14.21.9884 that was released on June 14th and this looks to have fixed my issue so far.
    * Update 6/27: Through further testing I have discovered that when I make additional connections to other servers and authenticate through Microsoft Entra MFA for each that only the first one that I connect to will work to show suggestions through SQL Prompt. If I restart SSMS and connect to the servers in a different order, then again, only the first one will show suggestions. It appears that maybe the token that SQL Prompt is using is not able to be used across all connections even though its the same Entra AAD account for each server. Maybe SQL Prompt needs to try to retrieve a new token for each connection. I'm just speculating of course on this based on what I'm currently seeing and the limited testing that I've done with this so far.
  • Options
    BrianBohnBrianBohn Posts: 2 New member
    Hey Everyone,

    It may be worth checking your Server version. I'm noticing on our 2016 Server that we aren't getting any recommendations, but our recently-updated 2022 Server doesn't appear to be having issues.
    I also recall seeing a few notifications regarding older Server versions would no longer be supported/compatible at some point, but it's been a few months and I can't remember if they were specific to SQL Prompt or not.
Sign In or Register to comment.