Upgrade from SA7.5 to 9 doesn't carry SN

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 !

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.

	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 ?

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.

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 ...

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.

	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

For version 9 you will need to request a new license key. Please email to support

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.

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

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

	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,

Awesome. Thank you very much for the status update