SQL Prompt 9

Error 80070002 - The Add-in SQL Prompt failed to load or caused an exception

When launching SQL Server Management Studio after installing SQL Prompt, the following error message may appear:

The Add-in 'SQL Prompt <version number>' failed to load or caused an exception. Would you like to remove this Add-in?

If you choose yes, you will need to reinstall the Add-in to use it again.

Error Message: The system cannot find the file specified.

Error number: 80070002

This error arises if extensibility.dll is missing.

To resolve this problem:

  1. Open a command prompt and change directory to the SQL Prompt installation folder.
  2. Run the following:
    For SQL Prompt 3.x: %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 3\RedGate.SQLPrompt.SSMSUI.dll" 
    For SQL Prompt 4.x: %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 4\RedGate.SQLPrompt.SSMSUI.dll" 
    For SQL Prompt 5.x: %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 5\RedGate.SQLPrompt.SSMSUI.dll"
    For SQL Prompt 6.x: %SYSTEMROOT%\Microsoft.net\Framework\v4.0.30319\regasm "%ProgramFiles%\Red Gate\SQL Prompt 6\RedGate.SQLPrompt.SSMSUI.dll" 
    For SQL Prompt 7.x: %SYSTEMROOT%\Microsoft.net\Framework\v4.0.30319\regasm "%ProgramFiles%\Red Gate\SQL Prompt 7\RedGate.SQLPrompt.SSMSUI.dll" 
    This will register SQL Prompt as a Management Studio add-in. 
  3. If the command is successful, run SqlWb.exe /setup (SQL Server Management Studio 2005) SSMS.exe /setup (SQL Server Management Studio 2008, 2008 R2 and 2012) to re-initialize SQL Server Management Studio's interface.

If the problem persists, it may be necessary to reinstall SQL Prompt:

  1. Open Add/Remove Programs or Programs and Features from the Windows Control Panel.
  2. Select SQL Prompt then click Repair.

Didn't find what you were looking for?