Could not load file or assembly RedGate.Update.Client.Interfaces

mrogers01

After updating to the newest version of SQL Prompt, I'm getting the following error when launching SSMS:

Could not load file or assembly 'RedGate.Update.Client.Interfaces, Version=3.0.0.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.

I checked in C:\Program Files (x86)\Red Gate\SQL Prompt 9\ and a file called RedGate.Update.Client.Interfaces.dll does not exist.  What do I need to do to fix this?

mrogers01

I was able to resolve this by uninstalling SQL Prompt and reinstalling from scratch. 

TomW

Hi @mrogers01

Thanks for reporting this! It's an issue we were quickly made aware, and it only occurs when upgrading Prompt. We've removed the release and will be releasing a new version today that resolves the issue.

Sorry for the inconvenience.

Tom
Team Prompt

AdrianB

This issue affected SQL Prompt 9.5.17.11486 and has since been fixed in SQL Prompt 9.5.18.11513.

DanBartmess

Problem is, how do I load the 9.5.18 update? None of the SQL Prompt functionality is working in SSMS, including check for updates. I can't seem to find a link to the latest update.

mrogers01

Hey DanBartmess, you should be able to download the installer from here: https://www.red-gate.com/dynamic/products/sql-development/sql-prompt/download.  If you can't update, you can uninstall from Control Panel and reinstall using the installer.

I found that it doesn't matter what version of the installer you have, it should install the most up-to-date version of SQL Prompt.