SQL Assistant tab not showing in SSMS

Hi

Im not able to get the SQL Assistant tab showing in SSMS when I open a query window

Running the diagnostics, i see this error:

Loading SqlAssist.CSmsAddin10... FAILED
Error = 0x80070002: The system cannot find the file specified.

Here is my sql assistant info
Version 10..0.187 Professional Edition
with a valid license

Here is my ssms info

Microsoft SQL Server Management Studio 14.0.17285.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17763.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.17763

Sql assistant is running on my machine, and in ssms if i right click on the object explorer db, i do see the SQL Assistant appear in the context menu

Also, all my sql assistant options do target SQL Server

However no sql assistant features work in my query window, like code snippets, intellisense

Thoughts?

I suggest to try disabling and reenabling the SQL Assistant add-on for SSMS. If something has changed in the system, it should refresh the registry entries and the integration files too

In the Target settings in the Options dialog find MS Management Studio, expand the Advanced section on the right, and change the value of "Register SQL Assistant Add-on" to No. Click Apply and then change it back to Yes, and apply again. After that restart the SSMS.

If that doesn't help, you may want to try installing a SQL Assistant upgrade. Version 10.0 is about 2 years old. Your Windows system surely had some patches installed, perhaps SSMS got updated too along with other dependencies and some files changed. The latest SQL Assistant version is 11.3. There've been lots of updates in versions 10.1, 10.2, 11.0, 11.1, 11.2, 11.3, you are currently behind by 6 releases. More details can be found here http://www.softtreetech.com/sqlassist/whatsnew11.htm. I don't know if upgrading is an option for you, but I kind of expect it to resolve the issue you are having. Along new features added, the maintenance releases provide software compatibility fixes, things change with time and require updates.