| Author |
Message |
neverden
Joined: 02 Dec 2008
Posts: 58
|
|
 SSMS 2012 Error |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Please start SSMS 2012 in Run As Administrator mode. That should help.
|
|
| Fri Feb 03, 2012 12:58 pm |
|
|
Valery
Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
Valery
Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation |
|
| |
|
SSMS x32, sorry.
but everything else is in place ...
|
|
| Sun Apr 29, 2012 2:18 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
Valery
Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
Valery
Joined: 27 Apr 2012
Posts: 5
Country: Russian Federation |
|
| |
|
Well, I wrote a letter in support.
Thank you.
|
|
| Fri May 04, 2012 3:56 am |
|
|
|
