Author |
Message |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
[SA 6.5.278] SA doesn't work with Sql Management Studio 2014 |
|
Hi. Trying to use SA with a fresh new installed Sql Management Studio 2014, pressing CTRL+SHIFT+F5 I get the error you can find in the attached image and, generally speaking, SA doesn't work at all.
Instead, SA works perfectly with Sql Management Studio 2005, already installed on the same PC (a Win 7 64 bit).
Obviously, I'd need some help
Thanks a lot in advance
Regards
Andrea
|
|
Thu Jun 05, 2014 10:47 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Have you registered SQL Assistant plugin for Sql Management Studio 2014 after you installed the new version?
|
|
Thu Jun 05, 2014 11:21 am |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
How? I have to do a re-installation?
In the list of registered targets in the options menu of SA, Sql Management Studio is already selected
Maybe the problem arises from the 64 bit of the Management Studio 2012?
Thanks
Andrea
|
|
Thu Jun 05, 2014 11:50 am |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
I did as follows:
- I have removed the 64bit version of MS Management Studio 2014
- I have installed the 32bit version of MS Management Studio 2014
- I removed and installed the last version of Sql Assistant
But, it still doesn't work. With almost the same error
Thanks
Andrea
|
|
Fri Jun 06, 2014 9:30 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Does SSMS 2014 show SQL Assistant listed in installed add-ins?
|
|
Fri Jun 06, 2014 9:42 am |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
Apologize: where do I have to check?
Thanks
|
|
Fri Jun 06, 2014 9:46 am |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
If you are meaning the menu bar of SSMS 2014, no, SA is not listed. In SMSS 2005, yes, there is the SA menu after the "Query" menu
Any help?
Thanks
Andrea
|
|
Sun Jun 08, 2014 11:16 am |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
Any news?
Thanks
Andrea
|
|
Tue Jun 10, 2014 11:49 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
As asked in the previous message, please check names of extensions and add-on listed in your SSMS settings, SQL Assistant should appear in that list and should be enabled. If it's not there or disabled, it obviously won't work.
I don't have your SSMS version locally and cannot tell you where to look for that list. In VS 2014, that list is in Tools/Options menu, Environment, then Extensions and Updates.
One other suggestion, try starting SSMS in Run as Administrator mode and see if extensions get enabled in that mode.
|
|
Tue Jun 10, 2014 12:31 pm |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
Thanks for your answer
I don't have VS installed, only SSMS 2014 and, as you can see from the snapshot, there isn't a the "Extension and Updates" menu you are talking about.
I tried starting SSMS in "Run as Administrator" mode, but it doesn't work
|
|
Tue Jun 10, 2014 12:51 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I'm afraid you didn't select the option in SQL Assistant setup to install add-ons for SSMS 2012/2014. There is a separate option for that.
You can also re-register and re-install add-ons for installed SSMS versions using SQL Assistant's Options dialog. Select MS Management Studio target, expand Advanced options on the right, set Register SQL Assistant Add-on to No, click the Apply button, then revert it back to Yes, and Apply again.
|
|
Wed Jun 11, 2014 12:53 am |
|
 |
Risk
Joined: 17 Nov 2008 Posts: 34 Country: Italy |
|
|
|
Thanks
I'm pretty sure I had choosen the option you mentioned
Anyway, now it works.
Thanks a lot for your help and your patience
Regards
Andrea
|
|
Wed Jun 11, 2014 2:33 am |
|
 |
|