[11.0.25 Pro] - doesn't integrate with SSMS

[11.0.25 Pro] - doesn't integrate with SSMS

I have used SSMS 17. I updated SQL assist from version 10 to version 11.0.25. But it stopped to work in SSMS. I then updated my SSMS to version 18.2 but it still doesn't work. Only when I am closing SSMS then SQL assist ask about open documents. I tried refreshing the cache by renaming folder ComponentModelCache or 18.0_IsoShell but it doesn't help.

sqlAssist.log
30.7.2019 17:20:37 SqlAssist.exe Server: CheckInstallation
30.7.2019 17:20:37 SqlAssist.exe Server: Create
30.7.2019 17:20:37 SqlAssist.exe SA=11.0.25; Exe=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
30.7.2019 17:20:37 SqlAssist.exe Client: Attach
30.7.2019 17:20:37 sacmd.exe SA=11.0.25; Exe=C:\Program Files (x86)\SQL Assistant 11\bin64\sacmd.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin64\sacmd.exe" /srv; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
30.7.2019 17:20:37 sacmd.exe Client: Attach
30.7.2019 17:20:38 Explorer.EXE SA=11.0.25; Exe=C:\WINDOWS\Explorer.EXE; Cmd=C:\WINDOWS\Explorer.EXE; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
30.7.2019 17:20:38 Explorer.EXE Client: Attach
30.7.2019 17:20:39 RtsCM64.exe SA=11.0.25; Exe=C:\Windows\RtsCM64.exe; Cmd="C:\Windows\RtsCM64.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
30.7.2019 17:20:39 RtsCM64.exe Client: Attach
30.7.2019 17:20:40 SqlAssist.exe Server: ShowPrefsForm
30.7.2019 17:20:41 SqlAssist.exe SA=11.0.25; Exe=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssistPrefs.dll
30.7.2019 17:20:41 SqlAssist.exe Prefs: Attach
30.7.2019 17:20:41 SqlAssist.exe fmPrefs: Create
30.7.2019 17:21:07 SqlAssist.exe fmPrefs: Cancel
30.7.2019 17:21:07 SqlAssist.exe fmPrefs: Release
30.7.2019 17:21:07 SqlAssist.exe fmPrefs: Destroy
30.7.2019 17:21:13 Ssms.exe SA=11.0.25; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
30.7.2019 17:21:13 Ssms.exe Client: Attach
30.7.2019 17:21:14 Ssms.exe Client: Create
30.7.2019 17:21:24 Ssms.exe Client: CreateTargetList
30.7.2019 17:21:25 Ssms.exe SA=11.0.25; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssistPrefs.dll
30.7.2019 17:21:25 Ssms.exe Prefs: Attach
30.7.2019 17:21:25 Ssms.exe TargetList: SetSuspend=0
30.7.2019 17:21:25 Ssms.exe TargetList: Create: Rok=1
30.7.2019 17:21:25 Ssms.exe TargetList: SetSuspend=0
30.7.2019 17:21:25 Ssms.exe TargetList: EnumWnd (class=VsTextEditPane)
30.7.2019 17:21:25 Ssms.exe Client: SetCbtHook
30.7.2019 17:22:08 ApplicationFrameHost.exe SA=11.0.25; Exe=C:\WINDOWS\system32\ApplicationFrameHost.exe; Cmd=C:\WINDOWS\system32\ApplicationFrameHost.exe -Embedding; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
30.7.2019 17:22:08 ApplicationFrameHost.exe Client: Attach
30.7.2019 17:22:12 CredentialUIBroker.exe SA=11.0.25; Exe=C:\Windows\System32\CredentialUIBroker.exe; Cmd="C:\Windows\System32\CredentialUIBroker.exe" AppContainer -Embedding; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
30.7.2019 17:22:12 CredentialUIBroker.exe Client: Attach
30.7.2019 17:22:22 CredentialUIBroker.exe Client: Detach
30.7.2019 17:24:00 Ssms.exe fmDocSave: Create
30.7.2019 17:24:02 Ssms.exe fmDocSave: Release
30.7.2019 17:24:03 Ssms.exe fmDocSave: Destroy
30.7.2019 17:24:03 Ssms.exe Client: CloseQuery
30.7.2019 17:24:03 Ssms.exe TargetList: CloseQuery 1
30.7.2019 17:24:03 Ssms.exe TargetList: CloseQuery: form closed
30.7.2019 17:24:03 Ssms.exe TargetList: CloseQuery: unloaded extensions
30.7.2019 17:24:03 Ssms.exe TargetList at $250F0290: Destroy
30.7.2019 17:24:05 Ssms.exe Prefs: Detach
30.7.2019 17:24:05 Ssms.exe UpdateTaskListInternal: wpar = -2, lpar = 0
30.7.2019 17:24:05 Ssms.exe Client: Destroy
30.7.2019 17:24:05 Ssms.exe Client: Detach
30.7.2019 17:24:20 SqlAssist.exe Server: ShowPopup

sadiag.log
*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 11
SQL Assistant version: 11.0.25
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
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: not 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... 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 ... REGISTERED
SSMS 2016 MEF ... TARGET NOT INSTALLED
SSMS 2017 MEF ... REGISTERED
SSMS 2019 MEF ... NOT REGISTERED

VS 2005 ... NOT REGISTERED
VS 2008 ... NOT REGISTERED
VS 2010, 2012, 2013, 2015 COM Add-on ... NOT REGISTERED
VS 2010 MEF ... TARGET NOT INSTALLED
VS 2012 MEF ... NOT REGISTERED
VS 2013 MEF ... TARGET NOT INSTALLED
VS 2015 MEF ... TARGET NOT INSTALLED
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

Please refer to http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=25289 for how to fix this issue.

As I mentioned in my post, I have already tried hints from that post, but it doesn't help me.

I'm installing 18.2 to see if it works for me. It appears that 18.2 was release by Microsoft 6 days ago, I'm going to check if they introduced any backward incompatible changes. The add-on in SQL Assistant 11.0 for SSMS version 18 was developed and tested against versions 18.0 and 18.1

We're not able to reproduce this.

Can you please delete the cache again?
Maybe you have it in multiple places and deleted wrong one?

I can state with a certainty that the latest SSM v18.2 release is backward compatible and the integration does work. Manual delete of the ComponentModelCache folder might be required thought after the installation of SSMS 18.2.

One more thing, you may also need to delete temporary files from %USERPROFILE%\AppData\Local\Temp

I tried to delete whole temp folder and renamed 18.0_IsoShell. After I started SSMS it asks me about missing settings and if I want to create one. After confirmation it creates new 18.0_IsoShell folder and fill it with stuff - including ComponentModelCache folder. If I change Registe SQL assistant addon in SQL assistant options for SSMS, it creates folder SoftTree Technologies in folder Extensions in 18.0_IsoShell. But SQL assistant is not active in SSMS. I have SQL assistant running in systray and even the general hooking is not helping with writing SQL code in SSMS. Only if I have not saved query and try close SSMS, it show SQL assistant question regarding saving not saved queries.

Ok, so it's not all gone.

1. Are you able to start SSMS in Run as Administrator mode? Do you see any differences?
2. In the SQL Assistant settings (right-click systray app, choose Options) in the Targets settings click SQL Server Management Studio on the left and then expand Advanced section on the right. Do you see the add-on registration setting set to Yes. What value do you see for the Environment Integration field?
3. Open %APPDATA%\SQL Assistant\11.0\SqlAssist.log file in Notepad, scroll to the bottom. Do you see any error or exceptions written in that log file? If yes, what do you see?

I'm having the same problem running v11.031. I've done everything recommended in this thread to no avail. My SqlAssist.log file contents:

8/5/2019 9:43:10 PM RTSHookInterop.exe Client: Detach
8/5/2019 9:45:47 PM sacmd.exe Prefs: Attach
8/5/2019 9:45:47 PM sacmd.exe Prefs: Detach
8/5/2019 9:45:47 PM sacmd.exe UpdateTaskListInternal: wpar = -2, lpar = 0
8/5/2019 9:45:49 PM SqlAssist.exe Server: CheckInstallation
8/5/2019 9:45:50 PM SqlAssist.exe Server: Create
8/5/2019 9:45:50 PM SqlAssist.exe Server: MergeOptions
8/5/2019 9:45:50 PM SqlAssist.exe SA=11.0.31; Exe=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe" /showversion; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssistPrefs.dll
8/5/2019 9:45:50 PM SqlAssist.exe Prefs: Attach
8/5/2019 9:45:50 PM SqlAssist.exe Server: MergeOptions MRT
8/5/2019 9:45:50 PM SqlAssist.exe SA=11.0.31; Exe=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.exe" /showversion; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
8/5/2019 9:45:50 PM SqlAssist.exe Client: Attach
8/5/2019 9:45:51 PM sqlassist_setup.tmp SA=11.0.31; Exe=C:\Users\srothman\AppData\Local\Temp\is-5CSM5.tmp\sqlassist_setup.tmp; Cmd="C:\Users\srothman\AppData\Local\Temp\is-5CSM5.tmp\sqlassist_setup.tmp" /SL5="$1F07A2,58745811,57856,C:\Users\srothman\Downloads\sqlassist_setup.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
8/5/2019 9:45:51 PM sqlassist_setup.tmp Client: Attach
8/5/2019 9:45:51 PM sacmd.exe SA=11.0.31; Exe=C:\Program Files (x86)\SQL Assistant 11\bin64\sacmd.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin64\sacmd.exe" /srv; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:45:51 PM sacmd.exe Client: Attach
8/5/2019 9:45:51 PM sqlassist_setup.tmp Client: Detach
8/5/2019 9:45:51 PM Explorer.EXE SA=11.0.31; Exe=C:\WINDOWS\Explorer.EXE; Cmd=C:\WINDOWS\Explorer.EXE; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:45:51 PM Explorer.EXE Client: Attach
8/5/2019 9:45:51 PM DllHost.exe SA=11.0.31; Exe=C:\WINDOWS\system32\DllHost.exe; Cmd=C:\WINDOWS\system32\DllHost.exe /Processid:{AB8902B4-09CA-4BB6-B78D-A8F59079A8D5}; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:45:51 PM DllHost.exe Client: Attach
8/5/2019 9:45:51 PM sqlassist_setup.exe Client: Detach
8/5/2019 9:45:56 PM SbieCtrl.exe SA=11.0.31; Exe=C:\Program Files\Sandboxie\SbieCtrl.exe; Cmd="C:\Program Files\Sandboxie\SbieCtrl.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:45:56 PM SbieCtrl.exe Client: Attach
8/5/2019 9:45:57 PM Ssms.exe SA=11.0.31; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
8/5/2019 9:45:57 PM Ssms.exe Client: Attach
8/5/2019 9:45:57 PM Ssms.exe Client: Create
8/5/2019 9:46:10 PM Ssms.exe Client: CreateTargetList
8/5/2019 9:46:10 PM Ssms.exe SA=11.0.31; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssistPrefs.dll
8/5/2019 9:46:10 PM Ssms.exe Prefs: Attach
8/5/2019 9:46:10 PM Ssms.exe TargetList: SetSuspend=0
8/5/2019 9:46:10 PM Ssms.exe TargetList: Create: Rok=1
8/5/2019 9:46:10 PM Ssms.exe TargetList: SetSuspend=0
8/5/2019 9:46:10 PM Ssms.exe TargetList: EnumWnd (class=VsTextEditPane)
8/5/2019 9:46:10 PM Ssms.exe Client: SetCbtHook
8/5/2019 9:46:28 PM firefox.exe SA=11.0.31; Exe=C:\Program Files\Mozilla Firefox\firefox.exe; Cmd="C:\Program Files\Mozilla Firefox\firefox.exe"; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:46:28 PM firefox.exe Client: Attach
8/5/2019 9:46:37 PM svchost.exe SA=11.0.31; Exe=C:\WINDOWS\system32\svchost.exe; Cmd=C:\WINDOWS\system32\svchost.exe -k ClipboardSvcGroup -p -s cbdhsvc; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:46:37 PM svchost.exe Client: Attach
8/5/2019 9:46:45 PM notepad++.exe SA=11.0.31; Exe=C:\Program Files (x86)\Notepad++\notepad++.exe; Cmd="C:\Program Files (x86)\Notepad++\notepad++.exe" "C:\Users\srothman\AppData\Roaming\SQL Assistant\11.0\SqlAssist.log"; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
8/5/2019 9:46:45 PM notepad++.exe Client: Attach
8/5/2019 9:47:13 PM SqlAssist.exe Server: ShowPopup
8/5/2019 9:47:16 PM SqlAssist.exe Server: ShowPrefsForm
8/5/2019 9:47:16 PM SqlAssist.exe fmPrefs: Create
8/5/2019 9:47:22 PM conhost.exe SA=11.0.31; Exe=C:\WINDOWS\system32\conhost.exe; Cmd=\??\C:\WINDOWS\system32\conhost.exe 0x4; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
8/5/2019 9:47:22 PM conhost.exe Client: Attach
8/5/2019 9:47:24 PM saDiag.exe SA=11.0.31; Exe=C:\Program Files (x86)\SQL Assistant 11\bin\saDiag.exe; Cmd="C:\Program Files (x86)\SQL Assistant 11\bin\saDiag.exe" /i; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
8/5/2019 9:47:24 PM saDiag.exe Client: Attach
8/5/2019 9:48:31 PM saDiag.exe Client: Detach
8/5/2019 9:50:02 PM SqlAssist.exe Server: ShowPopup
8/5/2019 9:50:04 PM SqlAssist.exe Server: ShowPrefsForm
8/5/2019 9:50:07 PM SqlAssist.exe fmPrefs: Release
8/5/2019 9:50:07 PM SqlAssist.exe fmPrefs: Destroy

And my saDiag.log:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 11
SQL Assistant version: 11.0.31
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
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 ... 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 REGISTRATION INFO
SSMS 2008 ... NO REGISTRATION 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 ... NOT REGISTERED
VS 2008 ... NOT REGISTERED
VS 2010, 2012, 2013, 2015 COM Add-on ... NOT 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 ... 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

I've uninstalled/reinstalled, cleared the ComponentModelCache folders for both Visual Studio 19 and SSMS 18.2 multiple times and I'm not sure what else to do. Everything was previously working but seems to have stopped once I installed v11. And, to answer you most recent questions, yes I tried running both SA and SSMS as Admin - don't see any difference. And Enviornment Integration is set to Full.

Interestingly, I do see the context menu for SA when I right-click on objects in the Object Explorer even though there's no other trace of it running.

SysOp wrote:

Ok, so it's not all gone.

1. Are you able to start SSMS in Run as Administrator mode? Do you see any differences?
2. In the SQL Assistant settings (right-click systray app, choose Options) in the Targets settings click SQL Server Management Studio on the left and then expand Advanced section on the right. Do you see the add-on registration setting set to Yes. What value do you see for the Environment Integration field?
3. Open %APPDATA%\SQL Assistant\11.0\SqlAssist.log file in Notepad, scroll to the bottom. Do you see any error or exceptions written in that log file? If yes, what do you see?

1. I can start it as admin with no difference.
2. add-on registration setting on Yes (I have changed it multiple times between yes and no). Environment integration field is set to Full.
3. no errors in log. Check it bellow
4. I can see SQL assist menu in right mouse menu in object explorer as seth.rothman
5. Updated to 11.0.31 without any change.

6.8.2019 9:40:27 taskhostw.exe SA=11.0.25; Exe=c:\windows\system32\taskhostw.exe; Cmd=taskhostw.exe KEYROAMING; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
6.8.2019 9:40:27 taskhostw.exe Client: Attach
6.8.2019 9:40:27 taskhostw.exe Client: Detach
6.8.2019 9:43:25 devenv.exe Client: Detach
6.8.2019 9:43:59 WINWORD.EXE Client: Detach
6.8.2019 9:44:42 PerfWatson2.exe Client: Detach
6.8.2019 9:48:13 SqlAssist.exe Server: ShowPopup
6.8.2019 9:48:16 SqlAssist.exe Server: ShowPrefsForm
6.8.2019 9:48:16 SqlAssist.exe fmPrefs: Create
6.8.2019 9:48:45 GamutLogViewer.exe SA=11.0.25; Exe=C:\Program Files (x86)\Gamut\LogViewer\GamutLogViewer.exe; Cmd="C:\Program Files (x86)\Gamut\LogViewer\GamutLogViewer.exe" "C:\Users\mgottvald\AppData\Roaming\SQL Assistant\11.0\SqlAssist.log"; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll
6.8.2019 9:48:45 GamutLogViewer.exe Client: Attach
6.8.2019 9:51:38 Ssms.exe SA=11.0.25; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll
6.8.2019 9:51:38 Ssms.exe Client: Attach
6.8.2019 9:51:38 Ssms.exe Client: Create
6.8.2019 9:51:52 Ssms.exe Client: CreateTargetList
6.8.2019 9:51:54 Ssms.exe SA=11.0.25; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssistPrefs.dll
6.8.2019 9:51:54 Ssms.exe Prefs: Attach
6.8.2019 9:51:54 Ssms.exe TargetList: SetSuspend=0
6.8.2019 9:51:54 Ssms.exe TargetList: Create: Rok=1
6.8.2019 9:51:54 Ssms.exe TargetList: SetSuspend=0
6.8.2019 9:51:54 Ssms.exe TargetList: EnumWnd (class=VsTextEditPane)
6.8.2019 9:51:54 Ssms.exe Client: SetCbtHook

Thank you. Can I ask for a favor. and try the following troubleshooting steps

1. Everybody who is having this issue, please run a search on your C drive to locate all instances of ComponentModelCache
Please let us know where you find them. Are there multiple copies? Where are they?

2. make sure you have all instances on SSMS and VS closed. Delete the found folders, After deleting open new Windows Explorer window and verify the folder(s) is/are actually gone. Windows UAC didn't restore them silently.

3. After SSMS restart, make sure you open new query tab. Do you see SQL Assistant in the right-click menu of that tab? If yes, you are good.

4. If no, locate the same folder again. In the folder find Microsoft.VisualStudio.Default.cache file and open it in Notepad
Search for "SqlAssist.vs.14.dll" string without quotes. You should find something like below

Code:

ation.dlliš–L¦3H *Ô/+Õ¬ CÚ;Microsoft.VisualStudio.Language.GenerateType.GenerateTypeUI CÛCÜ<Microsoft.VisualStudio.Language.GenerateType.IGenerateTypeUICÕ CÕ CÜCÕ@M CÝCÞCßCàFSqlAssist.vs.14, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullCáGfile:///C:/Program Files (x86)/SQL Assistant 11/bin/SqlAssist.vs.14.dllfÆêzF¡C¶ì9šP‹Câ!SqlAssist.SqlAssistVSAddinFactory CãCä?Microsoft.VisualStudio.Text.Editor.IWpfTextViewCreationListenerCÝ CÝ Cä@c@TCåSQLCæT-SQL90CçPL/SQLCèSQL Server ToolsCéSQLCEA#@TCêDOCUMENTCëCì;Microsoft.VisualStudio.Text.Editor.AdornmentLayerDefinitionCÝCíCÝCîeditorAdornmentLayerCïA( Cì CìA@TCðTextCñSqlAssistVSAddinA@TCòSelectionAndProvisionHighlightA#@TCêCóCìCÝCôCÝCõeditorAdornmentLayer2Cï CìA@T CöSqlAssistVSAddin2A@TCðA#@TCêCÝ C÷CÝCø
editorFactoryAYA_

If you didn't find it, there is a problem with the add-on registration or the cache is corrupted for some reason (which is a fairly common case with Visual Studio, but not fatal)
If you find it, check the path referenced there. Does it point to C:/Program Files (x86)/SQL Assistant 11/bin/SqlAssist.vs.14.dll or to some older version in a different folder?

Also check if there is a substring SqlAssistVSAddin referenced couple of lines below the path.

Lastly, just in case, you may want to see this one, that is for VS, but the same applies to SSMS which is based on VS Shell http://hermit.no/how-to-fix-visual-studio-loading-errors-using-ifix/

Last edited by SysOp on Tue Aug 06, 2019 11:06 am; edited 2 times in total

One more request, please check your %LOCALAPPDATA%\Microsoft\SQL Server Management Studio\18.0_IsoShell\ComponentModelCache\Microsoft.VisualStudio.Default.err file. You can open it in Notepad and check if it contains any errors collected while making the cache. While there is always something on systems with previous versions of SSMS installed, we are only interested in errors related to SQL Assistant.

Here are the locations of ComponentModelCache:

\AppData\Local\Microsoft\SQL Server Management Studio\18.0_IsoShell\ComponentModelCache
\AppData\Local\Microsoft\VisualStudio\16.0_1e2ae7c8

I definitely had VS2019 & SSMS 18.2 closed, deleted the folders and confirmed they weren't recreated. I tried restarting SSMS first, no luck. I deleted the folder (again) and tried VS first and then SSMS. Same result - no SQL Assistant working on the query window.

The reference to SqlAssist.vs.14.dll is located where you expected in the cache file.

In reviewing the .err file for SSMS, it's HUGE (740KB) but I don't see any reference to SQL Assistant. I searched for the word "SQL", "assist", etc. and didn't find anything related to SA.

FYI, I still have SSMS v17.9.1 on my machine so, as a last ditch effort, I opened that one up. It recreated its ComponentModelCache folder with a much smaller .err file (34KB) but no SA references. Its reference to SqlAssist.vs.14.dll is correct also.

This is a bit painful...

Thank you. Do you see any errors recorded in SQL Assistant log file when you start SSMS 18.2 and open new editor tab?

Last edited by SysOp on Tue Aug 06, 2019 11:59 pm; edited 1 time in total