Error 80070002 - The Add-in SQL Prompt failed to load or caused an exception
Published 29 October 2019
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:
- Open a command prompt and change directory to the SQL Prompt installation folder.
- 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. - 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:
- Open Add/Remove Programs or Programs and Features from the Windows Control Panel.
- Select SQL Prompt then click Repair.
