SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Upgrade from SA7.5 to 9 doesn't carry SN

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Upgrade from SA7.5 to 9 doesn't carry SN
Author Message
alibaigy



Joined: 11 Oct 2016
Posts: 6
Country: Canada

Post Upgrade from SA7.5 to 9 doesn't carry SN Reply with quote
Hi,

I do have SQL Assistant Professional. After upgrading to version 9, not only I lost my license, the new version removed the SQL Assistant menu from SSMS ! I used all the troubleshooting explained in the forum with no luck so I uninstalled V.9 and went back to SA 7.5. However, the SQL Assistant menu is gone for good !



Tue Oct 11, 2016 4:37 pm View user's profile Send private message
Mindflux



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

Post Reply with quote
Yes it seems new major versions require a new key. I put in a request for mine this morning but have yet to hear back.
Tue Oct 11, 2016 4:46 pm View user's profile Send private message
alibaigy



Joined: 11 Oct 2016
Posts: 6
Country: Canada

Post Reply with quote
Mindflux wrote:
Yes it seems new major versions require a new key. I put in a request for mine this morning but have yet to hear back.


How about the SSMS registration issue ? It was supposed to be fixed in the new release. Do you have the same problem ?
Tue Oct 11, 2016 4:49 pm View user's profile Send private message
Mindflux



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

Post Reply with quote
alibaigy wrote:
Mindflux wrote:
Yes it seems new major versions require a new key. I put in a request for mine this morning but have yet to hear back.


How about the SSMS registration issue ? It was supposed to be fixed in the new release. Do you have the same problem ?


SSMS works for me, but I'm using 2008R2 SSMS. I've for the most part switched over to their own SQL Editor because of the tighter integration with SQL Assistant.

I use SSMS now primarily for maintenance tasks like modifying tables and views and things that I cannot do via a GUI/wizard in SQL Editor.
Tue Oct 11, 2016 4:51 pm View user's profile Send private message
alibaigy



Joined: 11 Oct 2016
Posts: 6
Country: Canada

Post Reply with quote
Mindflux wrote:
alibaigy wrote:
Mindflux wrote:
Yes it seems new major versions require a new key. I put in a request for mine this morning but have yet to hear back.


How about the SSMS registration issue ? It was supposed to be fixed in the new release. Do you have the same problem ?


SSMS works for me, but I'm using 2008R2 SSMS. I've for the most part switched over to their own SQL Editor because of the tighter integration with SQL Assistant.

I use SSMS now primarily for maintenance tasks like modifying tables and views and things that I cannot do via a GUI/wizard in SQL Editor.


I see. I wanna use it on SSMS 2016 and it doesn't work. Wasted all my day today for troubleshooting ...
Tue Oct 11, 2016 5:26 pm View user's profile Send private message
Mindflux



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

Post Reply with quote
All I've seen on SSMS 2016 is to start SQL assistant "as administrator" and toggle the "Register SQL Assistant" addon from yes to no and hit apply and back to yes and hit apply in the advanced properties for the target config.

I'm sure by now you've done that.
Tue Oct 11, 2016 5:29 pm View user's profile Send private message
alibaigy



Joined: 11 Oct 2016
Posts: 6
Country: Canada

Post Reply with quote
Mindflux wrote:
All I've seen on SSMS 2016 is to start SQL assistant "as administrator" and toggle the "Register SQL Assistant" addon from yes to no and hit apply and back to yes and hit apply in the advanced properties for the target config.

I'm sure by now you've done that.


That , plus over 5 times install/ uninstall, restart, registry checking, command line stuff .... no use
Tue Oct 11, 2016 5:32 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
For version 9 you will need to request a new license key. Please email to support
Tue Oct 11, 2016 6:18 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
I'd like to clarify the previous message. To install the software you don't have to enter the license key right away. You will have 2 weeks to obtain the key and enter it.

I've noticed on your screenshot of the diagnostics log that SSMS add-on is not registered and it says the it cannot find the file. Please open SQL Assistant options, and then activate the Targets tab and select MS Management Studio. Expand the Advanced options section, set Register Addon option value to No and click the Apply button, then set it back to Yes, and click the Apply again.
Be sure that the license key on the about tab is either blank or a valid v9 license key entered. start SSMS 2016 again. If SQL Assistant is still not showing up, please open the Options again, and on the About tab click, "run diagnostics..." link. When diagnostics run completes, it will print a message in the console indicating location and name of the output log file. Please post the contents of your log file so we can see if anything is wrong there with SSMS registration.
Wed Oct 12, 2016 12:03 am View user's profile Send private message
alibaigy



Joined: 11 Oct 2016
Posts: 6
Country: Canada

Post Reply with quote
It didn't work. Here's the log:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 9
SQL Assistant version: 9.0.162
SqlAssist.exe ... OK
SqlEditor.exe ... OK
sacmd.exe ... OK
sareg.exe ... OK
saddl.exe ... OK
sascan.exe ... OK
sqleditor_std.exe ... OK
SQLEditor64.exe ... OK
sacmd64.exe ... OK
SqlAssist.pdf ... OK
data\SqlAssist.sas ... OK
data\SqlAssist.setup.sas ... OK
data\SqlAssistDTMap.xml ... OK
data\dbdiagram.themes ... OK
data\SqlAssist.dll ... OK
data\SqlAssistPrefs.dll ... OK
data\SqlAssist64.dll ... OK
data\SqlAssistPrefs64.dll ... OK
data\SqlAssist.Sms.dll ... OK
data\SqlAssist.Dbm.dll ... OK
data\SqlAssist.Ase.dll ... OK
data\SqlAssist.Dex.dll ... OK
data\SqlAssist.Mso.dll ... OK
data\SqlAssist.vs.dll ... OK
data\SqlAssist.vs.14.dll ... OK
data\SqlAssist.DocMng.dll ... OK
data\SqlAssist.mwb.dll ... OK
data\SqlAssist.mwb4.dll ... OK
data\SqlAssist.Ase4.dll ... OK
data\SqlAssist.Dex4.dll ... OK
data\SqlAssist.DDL.dll ... OK
data\SqlAssist.re.dll ... OK
data\SqlAssist.DocMng.dll ... OK
data\SqlAssist.Sms.Bars.dll ... OK
data\SqlAssist.SSMS2005.dll ... OK
data\SqlAssist.SSMS2005Ent.dll ... OK
data\SqlAssist.SSMS2005Std.dll ... OK
data\SqlAssist.SSMS2008.dll ... OK
data\SqlAssist.SSMS2008R2.dll ... OK
data\SqlAssist.SSMS2012.dll ... OK
data\SqlAssist.SSMS2014.dll ... OK
data\SqlAssist.SSMS2016.dll ... OK
data\SA_SqlEdit.dll ... OK
data\SA_SqlEdit9.bpl ... OK
data\SA_SqlEdit10.bpl ... OK
data\SA_SqlEdit11.bpl ... OK
data\SA_SqlEdit12.bpl ... OK
data\SA_SqlEdit14.bpl ... OK
data\SA_SqlEdit15.bpl ... OK
data\SA_SqlEdit16.bpl ... OK
data\SA_SqlEdit17.bpl ... OK
data\SA_SqlEdit18.bpl ... OK
data\SA_SqlEdit19.bpl ... OK
data\SA_SqlEdit20.bpl ... OK
data\SA_SqlEdit21.bpl ... OK
data\SA_SqlEdit22.bpl ... OK
data\SA_SqlEdit23.bpl ... OK
data\sqlite3.dll ... OK
data\sqlite3x64.dll ... OK
data\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 *
*************************************************************
Loading SqlAssist.CSqlClient... OK
Loading SqlAssist.CSmsAddin... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Dex.DotNetBars... OK
Loading SqlAssist.Dbm.DbManager... OK
Loading SqlAssist.Mso.Addin... OK
Loading SqlAssist.DDLLoader... OK
Loading SqlAssist.CSmsAddin10... FAILED
Error = -2147024894: The system cannot find the file specified.

Loading SqlAssist.MySQLWBAddin... OK
Loading SqlAssist.MySQLWBAddin4... OK
Loading SqlAssist.saRegExpr... 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
Loading SqlAssist.DTEInit... FAILED
Error = -2146234304

*************************************************************
* SQL Assistant Add-ons *
*************************************************************
SSMS 2005 ... REGISTERED FOR Current User and All Users
SSMS 2008 ... REGISTERED FOR Current User and All Users
SSMS 2012, 2014, 2016 COM Add-on ... REGISTERED
SSMS 2012 MEF ... REGISTERED FOR Current User and All Users
SSMS 2014 MEF ... REGISTERED
SSMS 2016 MEF ... REGISTERED

VS 2005 ... REGISTERED FOR Current User and All Users
VS 2008 ... REGISTERED FOR Current User and All Users
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 ... REGISTERED

MS Access ... REGISTERED FOR Current User and All Users

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
Wed Oct 12, 2016 12:01 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Please delete Visual Studio MEF cache files

All files from this folder C:\Users\user_name\AppData\Local\Microsoft\SQL Server Management Studio\13.0\ComponentModelCache\

And also all matching here C:\Users\user_name\AppData\Local\Microsoft\SQL Server Management Studio\13.0\Extensions\extensions.*.cache
Wed Oct 12, 2016 1:59 pm View user's profile Send private message
alibaigy



Joined: 11 Oct 2016
Posts: 6
Country: Canada

Post Reply with quote
SysOp wrote:
Please delete Visual Studio MEF cache files

All files from this folder C:\Users\user_name\AppData\Local\Microsoft\SQL Server Management Studio\13.0\ComponentModelCache\

And also all matching here C:\Users\user_name\AppData\Local\Microsoft\SQL Server Management Studio\13.0\Extensions\extensions.*.cache


Perfect ! That was the solution. It works like a Swiss watch now.

Thanks,
Wed Oct 12, 2016 2:04 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Awesome. Thank you very much for the status update
Wed Oct 12, 2016 2:30 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
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.