SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.0.25 Pro] - doesn't integrate with SSMS
Goto page Previous  1, 2, 3
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[11.0.25 Pro] - doesn't integrate with SSMS
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Thank you so much for confirming,
Thu Aug 08, 2019 10:58 pm View user's profile Send private message
mgottvald



Joined: 30 Jul 2019
Posts: 14
Country: Czech Republic

Post Reply with quote
I could confirm too that build 35 starts to integrate.
Fri Aug 09, 2019 4:14 am View user's profile Send private message
alex.s



Joined: 10 Mar 2022
Posts: 6

Post Reply with quote
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.
Thu Mar 10, 2022 5:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
I changed your user name to alex.s, please try it, you may need to reset your password to complete the change
Thu Mar 10, 2022 9:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
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.
Thu Mar 10, 2022 9:14 am View user's profile Send private message
alex.s



Joined: 10 Mar 2022
Posts: 6

Post Reply with quote
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!
Thu Mar 10, 2022 12:31 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Could you please launch the self-diagnostics test from the About tab or command line and share the results?
Thu Mar 10, 2022 2:11 pm View user's profile Send private message
alex.s



Joined: 10 Mar 2022
Posts: 6

Post Reply with quote
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

Mon Mar 14, 2022 4:05 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
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
Mon Mar 14, 2022 10:59 pm View user's profile Send private message
alex.s



Joined: 10 Mar 2022
Posts: 6

Post Reply with quote
Unfortunately, it didn't help even when everything is running in the admin mode..
Tue Mar 15, 2022 12:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
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.
Tue Mar 15, 2022 10:32 am View user's profile Send private message
alex.s



Joined: 10 Mar 2022
Posts: 6

Post Reply with quote
Ok, I will wait for the new release. Thanks!
Tue Mar 15, 2022 3:52 pm View user's profile Send private message
alex.s



Joined: 10 Mar 2022
Posts: 6

Post Reply with quote
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

Fri Apr 01, 2022 3:13 pm 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
Goto page Previous  1, 2, 3
Page 3 of 3

 
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.