[11.0.7 beta] Addon failing to register with SSMS 18.1

Installed the 11.0.7 beta this morning. Turned off Windows SmartScreen and ran the installer as Administrator, installer reported no issues. When launching SSMS 18.1 I fail to see the SQL Assistant plugin.

When I view the MS Management Studio screen in SQL Assistant Options, it says "Yes" for Register SQL Assistant Add-On.

Below is the result of the self-diagnostic tool, which indicates that SqlAssist.CSmsAddin10 failed. Any ideas what is going on?

Code:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 11
SQL Assistant version: 11.0.7
SqlAssist.exe ... OK
SqlEditor.exe ... OK
SqlEditor.exe ... OK
sacmd.exe ... OK
sacmd.exe ... OK
sareg.exe ... OK
saddl.exe ... OK
sascan.exe ... OK
sascan.exe ... OK
sqleditor_std.exe ... OK
saDiag.exe ... OK
saDiag.exe ... OK
SqlAssist.dll ... OK
SqlAssist.dll ... OK
SqlAssistPrefs.dll ... OK
SqlAssistPrefs.dll ... OK
bin\sqlite3.dll ... OK
bin64\sqlite3.dll ... OK
SqlAssist.mwb64.dll ... OK
SqlAssist.pdf ... OK
config\SqlAssist.sas ... OK
config\SqlAssist.setup.sas ... OK
config\SqlAssistDTMap.xml ... OK
config\dbdiagram.themes ... OK
SqlAssist.DocMng.dll ... OK
SqlAssist.Sms.dll ... OK
SqlAssist.vs.dll ... OK
SqlAssist.vs.14.dll ... OK
SqlAssist.dll ... OK
SqlAssistPrefs.dll ... OK
SqlAssist.Dbm.dll ... OK
SqlAssist.Ase.dll ... OK
SqlAssist.Dex.dll ... OK
SqlAssist.Mso.dll ... OK
SqlAssist.mwb.dll ... OK
SqlAssist.mwb4.dll ... OK
SqlAssist.Ase4.dll ... OK
SqlAssist.Dex4.dll ... OK
SqlAssist.DDL.dll ... OK
SqlAssist.re.dll ... OK
bin\SqlAssist.Sms.Bars.dll ... OK
SqlAssist.SSMS2005.dll ... OK
SqlAssist.SSMS2005Ent.dll ... OK
SqlAssist.SSMS2005Std.dll ... OK
SqlAssist.SSMS2008.dll ... OK
SqlAssist.SSMS2008R2.dll ... OK
SqlAssist.SSMS2012.dll ... OK
SqlAssist.SSMS2014.dll ... OK
SqlAssist.SSMS2016.dll ... OK
SqlAssist.SSMS2017.dll ... OK
bin\SA_SqlEdit.dll ... OK
bin\SA_SqlEdit9.bpl ... OK
bin\SA_SqlEdit10.bpl ... OK
bin\SA_SqlEdit11.bpl ... OK
bin\SA_SqlEdit12.bpl ... OK
bin\SA_SqlEdit14.bpl ... OK
bin\SA_SqlEdit15.bpl ... OK
bin\SA_SqlEdit16.bpl ... OK
bin\SA_SqlEdit17.bpl ... OK
bin\SA_SqlEdit18.bpl ... OK
bin\SA_SqlEdit19.bpl ... OK
bin\SA_SqlEdit20.bpl ... OK
bin\SA_SqlEdit21.bpl ... OK
bin\SA_SqlEdit22.bpl ... OK
bin\SA_SqlEdit23.bpl ... OK
bin\git-credential-winstore.exe ... OK

*************************************************************
* User registration *
*************************************************************
Access rights: elevated
UAC Level: DEFAULT NOTIFICATION (2)
Registration mode: Current User
All users serial ... NO
Current user serial ... NO
SQL Assistant is not registered

*************************************************************
* COM Objects (x86) *
*************************************************************
Loading SqlAssist.Dbm.DbManager... OK
Loading SqlAssist.DDLLoader... OK
Loading SqlAssist.saRegExpr... OK
Loading SqlAssist.CSqlClient... OK
Loading SqlAssist.CSmsAddin... OK
Loading SqlAssist.CSmsAddin10... FAILED
Error = 0x80070002: The system cannot find the file specified.

Loading SqlAssist.DTEInit... OK
Loading SqlAssist.MySQLWBAddin... OK
Loading SqlAssist.MySQLWBAddin4... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Dex.DotNetBars... OK
Loading SqlAssist.Mso.Addin... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK

*************************************************************
* SQL Assistant Add-ons *
*************************************************************
SSMS 2005 ... NO REGISTRAION INFO
SSMS 2008 ... NO REGISTRAION INFO
SSMS 2012, 2014, 2016 COM Add-on ... REGISTERED
SSMS 2012 MEF ... TARGET NOT INSTALLED
SSMS 2014 MEF ... TARGET NOT INSTALLED
SSMS 2016 MEF ... TARGET NOT INSTALLED
SSMS 2017 MEF ... REGISTERED
SSMS 2019 MEF ... REGISTERED

VS 2005 ... REGISTERED
VS 2008 ... REGISTERED
VS 2010, 2012, 2013, 2015 COM Add-on ... REGISTERED
VS 2010 MEF ... TARGET NOT INSTALLED
VS 2012 MEF ... TARGET NOT INSTALLED
VS 2013 MEF ... TARGET NOT INSTALLED
VS 2015 MEF ... TARGET NOT INSTALLED
VS 2017 MEF ... REGISTERED
VS 2019 MEF ... REGISTERED

MS Access ... NOT REGISTERED

Delphi 2005 ... NOT INSTALLED
Delphi 2006 ... NOT INSTALLED
Delphi 2007 ... NOT INSTALLED
Delphi 2009 ... NOT INSTALLED
Delphi 2010 ... NOT INSTALLED
Delphi XE ... NOT INSTALLED
Delphi XE 2 ... NOT INSTALLED
Delphi XE 3 ... NOT INSTALLED
Delphi XE 4 ... NOT INSTALLED
Delphi XE 5 ... NOT INSTALLED
Delphi XE 6 ... NOT INSTALLED
Delphi XE 7 ... NOT INSTALLED
Delphi XE 8 ... NOT INSTALLED
Delphi XE 10 ... NOT INSTALLED

SQL Assistant diagnostics completed ... WITH ERRORS

You may need to make SSMS to rebuilt its MEF cache so that it finds the ne addon.
That should be as simple as stopping SSMS, renaming %LOCALAPPDATA%\Microsoft\VisualSudio\16.0\ComponentModelCache and restarting SSMS.

Please let us know if this helps.

	SysOp wrote:
	You may need to make SSMS to rebuilt its MEF cache so that it finds the ne addon. That should be as simple as stopping SSMS, renaming %LOCALAPPDATA%\Microsoft\VisualSudio\16.0\ComponentModelCache and restarting SSMS. Please let us know if this helps.

I rebuilt the MEF cache (had to launch Visual Studio to get it to rebuild), but still not seeing the addon in SSMS.

It may be worth noting that I do see the addon within Visual Studio 2019.

Oh ok. That's good to know. Could you please search for ComponentModelCache under SQL Server Management Studio below %LOCALAPPDAT% and rename it too. I think that will do the trick.

	SysOp wrote:
	Oh ok. That's good to know. Could you please search for ComponentModelCache under SQL Server Management Studio below %LOCALAPPDAT% and rename it too. I think that will do the trick.

I renamed that folder to _Old and started SSMS 18. It recreated the folder and now SQL Assistant is working...the folder is located here: %LOCALAPPDATA%\Microsoft\SQL Server Management Studio\18.0_IsoShell\

	SysOp wrote:
	Oh ok. That's good to know. Could you please search for ComponentModelCache under SQL Server Management Studio below %LOCALAPPDAT% and rename it too. I think that will do the trick.

Same as jeffw8713, now that the cache was rebuilt everything appears to be working. Thank you.

Great. Glad it's working for you now. If there is anything else, please let us know.