SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Loading SqlAssist.CSmsAddin... FAILED

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Loading SqlAssist.CSmsAddin... FAILED
Author Message
adruzhinin



Joined: 22 Aug 2022
Posts: 2
Country: Russian Federation

Post Loading SqlAssist.CSmsAddin... FAILED Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Quote:
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
I have not had success getting SQL Assistant to work with SSMS 2019 either.

Code:

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)


Code:

*************************************************************
* 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Quote:
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
Quote:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
I hope so too, but it depends much on what Microsoft changed this time. I hope it's a preview version and simply ignores extensions in preview mode.

For Azure Data Studio please see our discussion here
https://www.softtreetech.com/support/phpBB2/viewtopic.php?t=25617
Mon Aug 22, 2022 3:21 pm View user's profile Send private message
adruzhinin



Joined: 22 Aug 2022
Posts: 2
Country: Russian Federation

Post Reply with quote
Quote:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
@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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
@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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.