SQL Prompt doesn't appear in SSMS

There are a few reasons why SQL Prompt may not appear in SQL Server Management Studio:

  • The version of SSMS may not be supported. See requirements here
  • While rare, you may have certain versions of other Redgate plugins which are conflicting. Try updating all of SQL Prompt, SQL Source Control, SQL Test, and SQL Search.
  • It may be missing from a newly installed version of SSMS.
  • It may disappear after upgrading SQL Prompt.

For the latter two, a simple reinstall should normally resolve the issue. If the problem persists, however, please try the steps below:

 

For SSMS 2012 and 2014:

The problem is likely with the SSMS Integration Pack Framework 1 (SIPFW) which is a set of files that our SSMS plugins use to integrate into SSMS 2014 and earlier.

This SIPFW used to be installed as a separate program and you may have files leftover from an older version of SIPFW.

To try a clean install:

  1. Open Add or Remove Programs 
  2. Uninstall SQL Prompt
  3. If it exists, uninstall  SSMS Integration Pack Framework 1 (not to be confused with the SSMS Integration Pack 1)
  4. Delete any of the following which still exist:
    • C:\Program Data\Redgate\SIPFW
    • C:\Program Files (x86)\Red gate\SQL Prompt X
    • C:\ProgramData\Microsoft\SQL Server Management Studio\XX.0\Addins\RedGate.SIPFramework.addin
    • C:\ProgramData\Microsoft\SQL Server Management Studio\XX.0\Addins\SQLPrompt.addin file
  5.  Reinstall SQL Prompt

 

For SSMS 2016 and 2017:

1. Open Add or Remove Programs 
2. Uninstall SQL Prompt
5. If it still exists, delete C:\Program Files (x86)\Red gate\SQL Prompt X
5. If it still exists, delete C:\Program Files (x86)\Microsoft SQL Server\XXX\Tools\Binn\ManagementStudio\Extension\SQLPrompt
6. Reinstall SQL Prompt

 

For SSMS 2018 and later:

1. Open Add or Remove Programs 
2. Uninstall SQL Prompt
5. If it still exists, delete C:\Program Files (x86)\Red gate\SQL Prompt X
5. If it still exists, delete C:\Program Files (x86)\Microsoft SQL Server\XXX\Tools\Binn\ManagementStudio\Extension\SQLPrompt
6. Reinstall SQL Prompt

 

If the problem still remains and you have a valid Support and Upgrades contract, please zip up any log files in %localappdata%\Local\Red Gate\Logs and send them to support@red-gate.com.

 

 

 

 

Was this article helpful?

1 out of 4 found this helpful
Have more questions? Submit a request