[11.0.25 Pro] - doesn't integrate with SSMS

Thank you so much for confirming,

I could confirm too that build 35 starts to integrate.

Hello Team, I just did a clean install and have the same issue. SSMS v18.10, SQL Assistant 12.0.191.

Ctrl + Shift + F5 shows exactly what people here described. Warning about the unsupported window class (

), None in the fields and disabled OK button. I can change everything except the Target Window Class and the OK button stays disabled.

Any idea how I can resolve this issue?

EDIT: noticed that my username is email. Is it possible to change it to something or delete my account? Tx in advance.

I changed your user name to alex.s, please try it, you may need to reset your password to complete the change

This message indicates that SQL Assistant add-on for SSMS is not installed, or not registered correctly. That's why everything is disabled. Please try disabling add-on in SQL Assistant options and then re-enabling it again. Usually that does the trick.

Yes, I've tried to disable and re-enable the add-on. I've even uninstalled and then re-installed the SQL Assistant. Basically, I followed all of the suggestions in this thread. Note that this is a fresh install (i.e. there were no previous versions of SSMS or anything like that, it is a new PC).

P.S. Thank you for changing the username!

Could you please launch the self-diagnostics test from the About tab or command line and share the results?

Sure, please check the attached. Btw, just to confirm, I did search for the ComponentModelCache folder, found it in VS and SSMS. Deleted both. Restarted PC. Started SSMS and it didn't help. After that, I've created this diag file.

Code:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 12
SQL Assistant version: 12.0.191
bin\SqlAssist.exe ... OK
bin\SqlEditor.exe ... OK
bin64\SqlEditor.exe ... OK
bin\sacmd.exe ... OK
bin64\sacmd.exe ... OK
bin\sareg.exe ... OK
bin\saddl.exe ... OK
bin\sascan.exe ... OK
bin64\sascan.exe ... OK
bin\sqleditor_std.exe ... OK
bin\saDiag.exe ... OK
bin64\saDiag.exe ... OK
bin\SqlAssist.dll ... OK
bin64\SqlAssist.dll ... OK
bin\SqlAssistPrefs.dll ... OK
bin64\SqlAssistPrefs.dll ... OK
bin\sqlite3.dll ... OK
bin\saResDrk.dll ... OK
bin\saResLgt.dll ... OK
bin64\sqlite3.dll ... OK
bin\SqlAssist.mwb64.dll ... OK
SqlAssist.pdf ... OK
config\SqlAssist.sas ... OK
config\SqlAssist.setup.sas ... OK
config\SqlAssistDTMap.xml ... OK
config\dbdiagram.themes ... OK
bin\SqlAssist.DocMng.dll ... OK
bin\SqlAssist.Sms.dll ... OK
bin\SqlAssist.vs.dll ... OK
bin\SqlAssist.vs.14.dll ... OK
bin\SqlAssist.dll ... OK
bin\SqlAssistPrefs.dll ... OK
bin\SqlAssist.Dbm.dll ... OK
bin\SqlAssist.Ase.dll ... OK
bin\SqlAssist.Dex.dll ... OK
bin\SqlAssist.Mso.dll ... OK
bin\SqlAssist.mwb.dll ... OK
bin\SqlAssist.mwb4.dll ... OK
bin\SqlAssist.Ase4.dll ... OK
bin\SqlAssist.Dex4.dll ... OK
bin\SqlAssist.DDL.dll ... OK
bin\SqlAssist.re.dll ... OK
bin\SqlAssist.Plugins.dll ... INCORRECT VERSION: 12.0.175
bin\SqlAssist.Sms.Bars.dll ... OK
bin\SqlAssist.SSMS2005.dll ... OK
bin\SqlAssist.SSMS2005Ent.dll ... OK
bin\SqlAssist.SSMS2005Std.dll ... OK
bin\SqlAssist.SSMS2008.dll ... OK
bin\SqlAssist.SSMS2008R2.dll ... OK
bin\SqlAssist.SSMS2012.dll ... OK
bin\SqlAssist.SSMS2014.dll ... OK
bin\SqlAssist.SSMS2016.dll ... OK
bin\SqlAssist.SSMS2017.dll ... OK
bin\SqlAssist.SSMS2019.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: not 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... FAILED
Error = 0x80070002: The system cannot find the file specified.

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

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 COM ... NO REGISTRATION INFO
SSMS 2008 COM ... NO REGISTRATION INFO
SSMS 2012 PCKG ... NOT REGISTERED
SSMS 2014 PCKG ... NOT REGISTERED
SSMS 2016 PCKG ... NOT REGISTERED
SSMS 2017 PCKG ... NOT REGISTERED
SSMS 2019 PCKG ... REGISTERED
SSMS 2012 MEF ... TARGET NOT INSTALLED
SSMS 2014 MEF ... TARGET NOT INSTALLED
SSMS 2016 MEF ... TARGET NOT INSTALLED
SSMS 2017 MEF ... TARGET NOT INSTALLED
SqlAssist.vs.14.dll not found in MEF Cache
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 ... NOT 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

Thank you. The log is showing that SQL Assistant's add-on for SSMS 2019 has been registered but is not getting loaded. This might be caused by security settings. Please try the following.

Close SSMS, and close SQL Assistant system tray application.
Start SQL Assistant in "Run as Administrator" mode. Right-click the SQL Assistant icon in the system tray and choose Options in the context menu to open the main Options dialog.
On the Targets tab, select SQL Server Management Studio, and then on the right expand the Advanced section.
Set the Register SQL Assistant Add-on option to No, and click the Apply button.
Now set the Register SQL Assistant Add-on option to Yes, and click the Apply button again.
Start SSMS in "Run as Administrator" mode, open new query window and verify SQL Assistant add-on is active in that window, you can simply right-click to see if the menu is there, or just start typing SELECT..
If that works, restart everything normally not using Run as Administrator mode and test SSMS again. If it works, you are done. If it doesn't, then it very likely the issue is caused by Windows User Account Control reverting some add-on registration or installation changes

Unfortunately, it didn't help even when everything is running in the admin mode..

I suspect there is some issue caused by conflicting setup for SSMS and VS, and yet I'm not able to pinpoint from here the exact place and reason. You would need to open a support case to troubleshoot it further. Or alternatively you can wait a bit and try version 12.1 expected by next Monday and see if it works for you. I know there are some internal updates in 12.1 containing code compatibility changes for latest Microsoft releases.

Ok, I will wait for the new release. Thanks!

Hello!

Unfortunately, I still have exactly the same issue after 12.1 release.. updated using the update button in the about dialog-> didn't work. Started as admin, unregistered, registered integration -> still doesn't work.

Any suggestions?
Tx!

Btw, I've noticed VS 2017 mentioned in the diag file. I don't have it installed, just FYI.

Here is another diag file (using admin access):

Code:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 12
SQL Assistant version: 12.1.270
bin\SqlAssist.exe ... OK
bin\SqlEditor.exe ... OK
bin64\SqlEditor.exe ... OK
bin\sacmd.exe ... OK
bin64\sacmd.exe ... OK
bin\sareg.exe ... OK
bin\saddl.exe ... OK
bin\sascan.exe ... OK
bin64\sascan.exe ... OK
bin\sqleditor_std.exe ... OK
bin\saDiag.exe ... OK
bin64\saDiag.exe ... OK
bin\SqlAssist.dll ... OK
bin64\SqlAssist.dll ... OK
bin\SqlAssistPrefs.dll ... OK
bin64\SqlAssistPrefs.dll ... OK
bin\sqlite3.dll ... OK
bin\saResDrk.dll ... OK
bin\saResLgt.dll ... OK
bin64\sqlite3.dll ... OK
bin\SqlAssist.mwb64.dll ... OK
SqlAssist.pdf ... OK
config\SqlAssist.sas ... OK
config\SqlAssist.setup.sas ... OK
config\SqlAssistDTMap.xml ... OK
config\dbdiagram.themes ... OK
bin\SqlAssist.DocMng.dll ... OK
bin\SqlAssist.Sms.dll ... OK
bin\SqlAssist.vs.dll ... OK
bin\SqlAssist.vs.14.dll ... OK
bin\SqlAssist.dll ... OK
bin\SqlAssistPrefs.dll ... OK
bin\SqlAssist.Dbm.dll ... OK
bin\SqlAssist.Ase.dll ... OK
bin\SqlAssist.Dex.dll ... OK
bin\SqlAssist.Mso.dll ... OK
bin\SqlAssist.mwb.dll ... OK
bin\SqlAssist.mwb4.dll ... OK
bin\SqlAssist.Ase4.dll ... OK
bin\SqlAssist.Dex4.dll ... OK
bin\SqlAssist.DDL.dll ... OK
bin\SqlAssist.re.dll ... OK
bin\SqlAssist.Plugins.dll ... OK
bin\SqlAssist.Sms.Bars.dll ... OK
bin\SqlAssist.SSMS2005.dll ... OK
bin\SqlAssist.SSMS2005Ent.dll ... OK
bin\SqlAssist.SSMS2005Std.dll ... OK
bin\SqlAssist.SSMS2008.dll ... OK
bin\SqlAssist.SSMS2008R2.dll ... OK
bin\SqlAssist.SSMS2012.dll ... OK
bin\SqlAssist.SSMS2014.dll ... OK
bin\SqlAssist.SSMS2016.dll ... OK
bin\SqlAssist.SSMS2017.dll ... OK
bin\SqlAssist.SSMS2019.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 ... YES
Current user serial ... YES

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

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

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 COM ... NO REGISTRATION INFO
SSMS 2008 COM ... NO REGISTRATION INFO
SSMS 2012 PCKG ... NOT REGISTERED
SSMS 2014 PCKG ... NOT REGISTERED
SSMS 2016 PCKG ... NOT REGISTERED
SSMS 2017 PCKG ... NOT REGISTERED
SSMS 2019 PCKG ... REGISTERED
SSMS 2012 MEF ... TARGET NOT INSTALLED
SSMS 2014 MEF ... TARGET NOT INSTALLED
SSMS 2016 MEF ... TARGET NOT INSTALLED
SSMS 2017 MEF ... TARGET NOT INSTALLED
SqlAssist.vs.14.dll not found in MEF Cache
SSMS 2019 MEF ... REGISTERED

VS 2005 ... NOT REGISTERED
VS 2008 ... NOT 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
CU: Manifest file not found: C:\Users\UserName\AppData\Local\Microsoft\VisualStudio\15.0\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\extension.vsixmanifest
VS 2017 MEF ... REGISTRATION ERROR
VS 2017 MEF ... NOT REGISTERED
VS 2019 MEF ... NOT 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