| Author |
Message |
adruzhinin
Joined: 22 Aug 2022
Posts: 2
Country: Russian Federation |
|
 Loading SqlAssist.CSmsAddin... FAILED |
 |
Can't get SQL Assistant for SSMS to work, diagnostics log:
*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\SQL Assistant 11
SQL Assistant version: 11.5.362
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: not elevated
UAC Level: DEFAULT NOTIFICATION (2)
Registration mode: Current User
All users serial ... NO
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: Не удается найти указанный файл.
Loading SqlAssist.CSmsAddin10... FAILED
Error = 0x80070002: Не удается найти указанный файл.
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
SSMS 2019 MEF ... NOT REGISTERED
VS 2005 ... NO REGISTRATION INFO
VS 2008 ... NO REGISTRATION INFO
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 ... NO REGISTRATION INFO
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
Installer was run "As Administrator", so doesn't seem to be user-related problem.
Checked another topic, tried to refresh MEF cache (whatever that is) - renamed and recreated AppData\Local\Microsoft\SQL Server Management Studio\18.0_IsoShell
Still no luck.
Would appreciate some help.
Maybe it has something to do with this - "SSMS 2019 MEF ... NOT REGISTERED"
|
|
| Mon Aug 22, 2022 7:48 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
 |
|
Maybe it has something to do with this - "SSMS 2019 MEF ... NOT REGISTERED" |
Agree, this is a sign, that SQL Assistant add-on isn't found in SSMS MEF cache, and it's a sign, the add-on isn't installed correctly. I recommend couple of things to try.
1. In SQL Assistant settings locate Targets -> SQL Server Management Studio -> Advanced -> Register SQL Server Add-on ->Yes
2. Same as 1, run SQL Assistant in Run as Administrator mode, repeat the above, then start SSMS in Run as Administrator mode and check if the add-on registration succeeds.
|
|
| Mon Aug 22, 2022 8:37 am |
|
|
Mindflux
Joined: 25 May 2013
Posts: 846
Country: United States |
|
| |
|
I have not had success getting SQL Assistant to work with SSMS 2019 either.
 |
|
8/22/2022 8:40:23 AM Ssms.exe Target: Destroy
8/22/2022 8:40:23 AM Ssms.exe fmDocSave: Release
C#: ~SqlAssistVSAddin()
8/22/2022 8:40:24 AM Ssms.exe Prefs: Detach
8/22/2022 8:40:24 AM Ssms.exe TargetList at $24547EA0: Destroy
8/22/2022 8:40:24 AM Ssms.exe TargetList: Save SQL Server Management Studio
8/22/2022 8:40:25 AM Ssms.exe UpdateTaskListInternal: wpar = -2, lpar = 0
8/22/2022 8:42:16 AM FileCoAuth.exe SA=12.1.279; Exe=C:\Program Files\Microsoft OneDrive\22.151.0717.0001\FileCoAuth.exe; Cmd="C:\Program Files\Microsoft OneDrive\22.151.0717.0001\FileCoAuth.exe" -Embedding; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 12\bin64\SqlAssist.dll; ImageBase=0000000008080000
8/22/2022 8:42:16 AM FileCoAuth.exe Client: Attach
8/22/2022 8:42:22 AM FileCoAuth.exe Client: Detach
8/22/2022 8:42:55 AM Ssms.exe SA=12.1.279; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 12\bin\SqlAssist.dll; ImageBase=08080000
8/22/2022 8:42:55 AM Ssms.exe Client: Attach
8/22/2022 8:42:56 AM Ssms.exe Client: Create
8/22/2022 8:42:59 AM Ssms.exe Client: CreateTargetList
8/22/2022 8:42:59 AM Ssms.exe SA=12.1.279; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 12\bin\SqlAssistPrefs.dll; ImageBase=26C50000
8/22/2022 8:42:59 AM Ssms.exe Prefs: Attach
8/22/2022 8:42:59 AM Ssms.exe TargetList: SetSuspend=0
8/22/2022 8:42:59 AM Ssms.exe TargetList: Create: Rok=1
8/22/2022 8:42:59 AM Ssms.exe TargetList: SetSuspend=0
8/22/2022 8:43:00 AM Ssms.exe TargetList: EnumWnd (class=VsTextEditPane) |
|
|
*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 12
SQL Assistant version: 12.1.279
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: 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... 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
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
|
|
|
| Mon Aug 22, 2022 9:27 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
|
|
SSMS 2019 MEF ... REGISTERED
|
this one is looking good. Are you getting any errors on startup?
Is that the latest SSMS 19 Preview 3 version?
|
|
| Mon Aug 22, 2022 12:12 pm |
|
|
Mindflux
Joined: 25 May 2013
Posts: 846
Country: United States |
|
| |
|
|
|
|
|
SSMS 2019 MEF ... REGISTERED
|
this one is looking good. Are you getting any errors on startup?
Is that the latest SSMS 19 Preview 3 version? |
No errors, no toolbars.. nothing. SSMS 19 P3.
Here's what ssms.exe -log C:\temp\ssms.log spits out
https://pastebin.com/9cX1PybL
SSMS 18 (latest) still works.
|
|
| Mon Aug 22, 2022 12:13 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
No references to SQL Assistant add-in even though it appears to be registered successfully. It might be that the Preview 3 version isn't loading extensions and addins, or isn't backward compatible. We will need to investigate it .
Last edited by SysOp on Mon Aug 22, 2022 3:15 pm; edited 1 time in total |
|
| Mon Aug 22, 2022 1:05 pm |
|
|
Mindflux
Joined: 25 May 2013
Posts: 846
Country: United States |
|
| |
|
|
|
No references to SQL Assistantadd-in even though it appearsto be registered successfully. It might be that the Preview 3 version isn't loading extensions and addins, or isn't backward compatible. We will need to investigate it . |
Thanks.
Hopefully it's an easy fix! Are there plans for the future for Azure Data Studio to work with S.A?
|
|
| Mon Aug 22, 2022 2:05 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
|
| Mon Aug 22, 2022 3:21 pm |
|
|
adruzhinin
Joined: 22 Aug 2022
Posts: 2
Country: Russian Federation |
|
| |
|
|
|
Agree, this is a sign, that SQL Assistant add-on isn't found in SSMS MEF cache, and it's a sign, the add-on isn't installed correctly. I recommend couple of things to try.
1. In SQL Assistant settings locate Targets -> SQL Server Management Studio -> Advanced -> Register SQL Server Add-on ->Yes |
Worked like a charm, thanks!
|
|
| Tue Aug 23, 2022 2:49 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
@Mindflux We investigated the case of SSMS v19 (a.k.a SSMS 2022) Preview version 3, and indeed it's not compatible with the the latest SQL Assistant add-in, it requires a new assembly for the add-in integration. The good news, the internal SSMS/Visual Studio API seems to be backward compatible with v18. We expect the upcoming SQL Assistant maintenance version to support v19. I'm unable to provide a release date yet, we are still developing that maintenance version.
|
|
| Tue Aug 23, 2022 10:06 am |
|
|
Mindflux
Joined: 25 May 2013
Posts: 846
Country: United States |
|
| |
|
|
|
@Mindflux We investigated the case of SSMS v19 (a.k.a SSMS 2022) Preview version 3, and indeed it's not compatible with the the latest SQL Assistant add-in, it requires a new assembly for the add-in integration. The good news, the internal SSMS/Visual Studio API seems to be backward compatible with v18. We expect the upcoming SQL Assistant maintenance version to support v19. I'm unable to provide a release date yet, we are still developing that maintenance version. |
Thanks for the update!
|
|
| Tue Aug 23, 2022 10:27 am |
|
|
|
