SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SSMS 2012 Error

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SSMS 2012 Error
Author Message
neverden



Joined: 02 Dec 2008
Posts: 58

Post SSMS 2012 Error Reply with quote
I get this error when I start SSMS 2012:


---------------------------
Microsoft SQL Server Management Studio
---------------------------
The Add-in 'SQL Assistant VS Add-In' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, you will need to reinstall the Add-in to use it again.

Error Message: Class not registered


Error number: 80040154
---------------------------
Yes No
---------------------------
Fri Feb 03, 2012 11:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Please start SSMS 2012 in Run As Administrator mode. That should help.
Fri Feb 03, 2012 12:58 pm View user's profile Send private message
Valery



Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation

Post Reply with quote
Did everything according to instructions.
In win7x64 and SSMS 2012 (x64) does not work.
Error 80040154.
I had to edit handles all of the registers
in the HKEY_CURRENT_USER \ Software \ Classes \ SqlAssist.SmsAddin10
and HKEY_CLASSES_ROOT \ Wow6432Node \ CLSID \ {754 073-xxx And more...

When installation program's prescribed the wrong values of registers.
Checked Microsoft Process Monitor.
Please, correct.
Fri Apr 27, 2012 2:37 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Are you sure you are running 64-bit version of SSMS 2012? Can you please verify in the task manager.

SQL Assistant is a 32-bit application and won't work with 64-bit editors and development tools.
Fri Apr 27, 2012 8:22 am View user's profile Send private message
Valery



Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation

Post Reply with quote
SSMS x32, sorry.
but everything else is in place ...
Sun Apr 29, 2012 2:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Please close SSMS. Restart SQL Assistant in Run as Administrator mode. Double click SQL Assistant system tray icom to open Options dialog. On the targets tab select MS Management Studio, expand Advamced section on the right; change Register addon option to False, click Apply button; then change the same option to True and click Apply button again: That should dod it. Start SSMS and the addon should load this time:
Sun Apr 29, 2012 7:06 am View user's profile Send private message
Valery



Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation

Post Reply with quote
I was doing this dozens of times.
Then all the same rules manually.
At the same time, or you can configure Visual Studio, or SSMS.
Registers overwrite each other.
I'm all set up, but it would be better if it was done by the installer ...
Thu May 03, 2012 5:23 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Thank you.

We actually came across the same issue yesterday while investigation some other support case. It appears on 64-bit versions of Windows 7 with the latest SSMS 2012 build, caused by 64-bit/32-bit registry virtualization issue (Windows registry reflection for 32-bit applications). SSMS 2012 doesn't read from the same part of the registry where we expect it to read the required add-on entries, it seems like its somehow bypassing virtualization for 32-bit applications.

Please email to support and refer to this topic, we will provide you with a registry import file to setup the add-on for SSMS 2012.
Thu May 03, 2012 10:26 am View user's profile Send private message
Valery



Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation

Post Reply with quote
Well, I wrote a letter in support.
Thank you.
Fri May 04, 2012 3:56 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.