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

SQL Prompt Wont appear in SSMS 21

Hi

I can understand that SQL Promt should work in SSMS 21 now from this post:
https://documentation.red-gate.com/sp/getting-started/installing-and-running-sql-prompt

I have tried to install newest version

I have tryed to uninstall SQL Promt and reinstalling it again, but the plugin wont work or appear in the Extensions menu.

I have the latest SSMS preview and the latest SQL Promt versions

Anyone who can help?

Rasmus
3

Comments

15 comments

Sort by
  • Vic
    Official comment

    Hi Rasmus 

    SQL Prompt added preview support for SSMS 21 as of version v10.16.6. It's possible to patch into a current version of Prompt and add it into SSMS 21 for usage.
     
    The latest version V10.16.8 can be accessed here:
    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.16.11.16409.exe 
     
    It may be necessary to make some changes to settings in SSMS 21 to enable the Redgate extensions, please refer to this guide and the section Running SQL Prompt with SSMS 21 Preview:
    https://documentation.red-gate.com/sp/getting-started/installing-and-running-sql-prompt
     
    The main setting to check is that both SQL Prompt extensions are disabled in the Extensions > Customize Menu... menu selection.

    Vic
  • Rasmus

    Hi 

    Thanks for replying on my ticket.

    I have version: SQL Promt 10.16.11.16409 installed (as mentioned tryed to uninstall the old and install again):
     

     

    And SSMS 21.0.0 Preview 6.0:
     

     

    The extension doesn't show up in:
     

    Niether does the menu:

    Rasmus
    1
  • Vic

    Hi Rasmus @... 

    How are you installing SQL Prompt; are you installing on both SSMS and VS or just SSMS? 

    Are you installing the software or is an admin installing it for you (is the installer being run as a different user to the one running SSMS?) 

    Does SQL Prompt appear in other versions of SSMS that you have installed? 

    Vic
    0
  • Rasmus

    In the installation proces i choose both SSMS and VS.

    It is me who has executed the installation, and i have done it both with my own user and tryed to elevate it to administrator. 

    SQL Promt works fine in SSMS 20.2.30.0 and in VS 2022 Version 17.13.6 on the same server

    Rasmus
    0
  • ted

    I have tried multiple times to get Sql Prompt installed on SSMS 20.0 preview 7 and have been unsuccessful.  

    ted
    0
  • Vic

    Hi all

    Please can you try uninstalling SSMS 21 and SQL Prompt and then reinstall, SSMS first and then SQL Prompt, to see if that fixes the issue.

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

    Vic
    1
  • Rasmus

    It worked

    The only difference in the installation is that I placed the program files folder in the suggested place instead of on our application drive as we usually do.

    Thanks for your support

    Rasmus
    0
  • Ed Carden

    FYI - Grant Fitchey left a post today saying he can see SQL Prompt in his 21.X preview version  of SSMS

    Ed Carden
    0
  • Rasmus

    Just did the installation again on a new server.

    Both Visual studio and SSMS 21 preview 6 are installed on our applikation drive (E) and same result as ealier.

    Visual studio is working with SQL Promt

    SSMS 21 Preview 6 is not working with SQL promt.

    seems like SQL Promt can't find it on other drives.

    On this server i can't install it on C so is there a work aorund for this ?

    Rasmus
    0
  • RightTurnsOnly

    It was working in the preview for me, but now that SSMS 21 has gone GA, Prompt is no longer working.  RedGate, can you please flip whatever switch needs to be flipped to enable Prompt with the GA release?  Thanks.

    RightTurnsOnly
    8
  • Klaus Ondrich

    It was working with all SSMS 21 Preview versions, but even the current SQL Prompt version 10.16.12 does not appear after installing release version of SSMS 21 and reinstalling SQL Prompt (and SQL Search).
    I know the manual to enable it with customizing Extensions Menu, bit SQL Prompt is not listed there anymore. I guess because the Preview version used the Preview channel and folder and the Release version uses the Release channel and folder. Maybe other internal folder/registry path settings should refer to the Release channel now.

    Klaus Ondrich
    8
  • kiinxx00

    You will note it is still currently installing under the Extensions Preview folder-

    C:\Program Files\Microsoft SQL Server Management Studio 21\Preview\Common7\IDE\Extensions

     

    Copy the entire SQLPrompt folder from the Preview folder to the Release folder-

    C:\Program Files\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\Extensions

     

    It will now work

    kiinxx00
    7
  • Klaus Ondrich

    Thank you for the hint. I didn't look into the folders myself until then.
    Yes, SQL Prompt and SQL Search menu buttons appear after moving the files from Preview to Release folder.
    SQL Prompt settings and code suggestions are working.

    However, an empty tab is opened when clicking the SQL History or SQL Search button.

    Klaus Ondrich
    0
  • ADAM WORONIEC

    After fussing with where the files were being installed, I can view the 2 SQL Prompt listings in the extension menu, and have unchecked them, but doing this makes no changes, and cannot get any SQL prompt functionality working beyond seeing them on that list.  

    ADAM WORONIEC
    0
  • Curtis

    I believe you need to remember to click on the ‘Save and Restart’ button after you uncheck the boxes.

    Curtis
    1

Add comment

Please sign in to leave a comment.