SQL Prompt, SQL Search, SQL Source Control or SQL Test doesn't appear in SSMS

There are a few reasons why one of our SSMS plug-ins may not appear in SQL Server Management Studio:

  • The version of SSMS may not be supported. Check the 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.
  • The Redgate Toolbar may be collapsed because it doesn't fit in its current location, as below. This is common with SSMS 2016 and later. 

You can drag the Redgate toolbar to another area to get all of the buttons to appear on screen.

  • It may be missing from a newly installed version of SSMS.
  • It may disappear after upgrading.

For the latter two, a simple repair or reinstall should normally resolve the issue. (If the tool isn't listed as installed in Control Panel but the installer says it's already installed, please open a ticket here for guidance.)

Should the repair or reinstall not help, 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.

This can sometimes be fixed by repairing the SIPFW installation:

  1. Open Programs and Features
  2. Right-click SSMS Integration Pack Framework 1 and select Repair

You should now be able to access the plug-in normally but if it still doesn't appear in SSMS try a clean install:

  1. Open Add or Remove Programs 
  2. Uninstall the tool
  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\<Name of tool> 
    • C:\ProgramData\Microsoft\SQL Server Management Studio\XX.0\Addins\RedGate.SIPFramework.addin
    • C:\ProgramData\Microsoft\SQL Server Management Studio\XX.0\Addins\<NameOfTool>.addin file
  5.  Reinstall the tool

For SSMS 2016 and 2017:

1. Open Add or Remove Programs 
2. Uninstall the tool
5. If it still exists, delete C:\Program Files (x86)\Red gate\<Name of tool>
5. If it still exists, delete C:\Program Files (x86)\Microsoft SQL Server\XXX\Tools\Binn\ManagementStudio\Extensions\<Name of tool>
6. Reinstall the tool

For SSMS 2018 and later:

1. Open Add or Remove Programs 
2. Uninstall the tool
5. If it still exists, delete C:\Program Files (x86)\Red gate\<Name of tool>
5. If it still exists, delete C:\Program Files (x86)\Microsoft SQL Server Management Studio XX\Common7\IDE\Extensions\<Name of tool>
6. Reinstall the tool

 

If the problem persists, please zip any log files in %localappdata%\Local\Red Gate\Logs, create a support request here and attach the file.

 

 

 

 

Was this article helpful?

2 out of 6 found this helpful
Have more questions? Submit a request