Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Beta in SSMS Add-In Failure - Class not registered |
|
v. 3.0.20 BETA
Installed SQL Assistant with SSMS closed. Launched SQL Assistant. Launched SSMS. Received below error on startup. Uninstalled, installed, same error.
---------------------------
Microsoft SQL Server Management Studio
---------------------------
The Add-in 'SQL Assistant SSMS 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
---------------------------
|
|
Tue Nov 13, 2007 10:39 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7847
|
|
|
|
You likely had or still having an older version of SQL Assistant installed on the same machine in a different directory. To fix this, open SQL Assistant options, locate SSMS target, expand advanced options and uncheck the Add-on option. Click the Apply button and it should remove old entries for the add-on from the registry. Check the Add-on checkbox again and click Apply. It should update the registry and save the correct path. Quit SQL Assistant's Options dialog and sys tray application. Start SSMS and open .any query window. The SQL Assistant should appear in the menu and function as usual.
|
|
Tue Nov 13, 2007 10:52 am |
|
![](templates/GreenTech/images/spacer.gif) |
ChuckR80010
Joined: 13 Nov 2007 Posts: 4 Country: United States |
|
|
|
I am having the same problems as Judahr, I do not have a previous version installed on this system. But I am receiving the same error message as the previous post.
|
|
Tue Nov 13, 2007 11:15 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7847
|
|
|
|
Please try the same method as described above. It should fix the issue. Please let us know if it doesn't help.
|
|
Tue Nov 13, 2007 11:27 am |
|
![](templates/GreenTech/images/spacer.gif) |
ChuckR80010
Joined: 13 Nov 2007 Posts: 4 Country: United States |
|
|
|
Did Not help, same problem occurs.
|
|
Tue Nov 13, 2007 11:56 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7847
|
|
|
|
I will log this case for review in development. A couple of questions that I need answers for.
Which version of SSMS are you running?
Is SQL Assistant helping with SSMS target after this error or it is not working at all?
Do you have Visual Studio installed on the same computer by any chance?
|
|
Tue Nov 13, 2007 12:38 pm |
|
![](templates/GreenTech/images/spacer.gif) |
ChuckR80010
Joined: 13 Nov 2007 Posts: 4 Country: United States |
|
|
|
Which version of SSMS are you running?
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
Is SQL Assistant helping with SSMS target after this error or it is not working at all? Yes, it just isn't showing up in the menu. And I get a the error message on load.
Do you have Visual Studio installed on the same computer by any chance? Yes VS 2005 pro.
|
|
Tue Nov 13, 2007 12:57 pm |
|
![](templates/GreenTech/images/spacer.gif) |
jamiesw
Joined: 13 Nov 2007 Posts: 1
|
|
|
|
I had the same error message as well.
I followed your instructions and it seemed to resolve my problem
Windows vista premium
SQL Server 2005 Developer Edition
VS Team Studio 2005
|
|
Tue Nov 13, 2007 2:16 pm |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
I followed the steps as well. No go.
Versions:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
VS 2005 Team SP1
|
|
Tue Nov 13, 2007 3:48 pm |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
Followed the steps again. Initially received the "Class not registered" pop-up. I now have pop-up help, but no context menu options.
|
|
Tue Nov 13, 2007 3:57 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7847
|
|
|
|
Let's try this
1. Start SSMS. You should get an error that it failed to load the add-in and a prompt to keep or remove. Choose to remove it.
2. Make sure the SQL Assistant running as a sys tray application
3. In SSMS open new query window. Type SELECT and then space. SQL Assistant should popup after SELECT
4. Press Esc to close it. Double-click on the Options, find "MS Management Studio" in targets and expand Advanced Options.
5. Select "True" for Register SQL Assistant Add-on option. Click the Apply button.
6. Restart SSMS. Open a new query. SQL Assistant menu should appear in SSMS menu.
|
|
Tue Nov 13, 2007 4:35 pm |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
In step 6, when restarting SSMS, it pops up with class not registered.
|
|
Wed Nov 14, 2007 10:17 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7847
|
|
|
|
Can anybody who is having this issue, post the contents of HKEY_CLASSES_ROOT\CLSID\{754CF073-05B3-4E97-880D-1D88D8D514BE} key?
You can use the registry editor regedit.exe to open this key and export to a .REG file. Please post the text from the REG file.
|
|
Thu Nov 15, 2007 1:01 am |
|
![](templates/GreenTech/images/spacer.gif) |
ChuckR80010
Joined: 13 Nov 2007 Posts: 4 Country: United States |
|
|
|
-- Can anybody who is having this issue, post the contents of HKEY_CLASSES_ROOT\CLSID\{754CF073-05B3-4E97-880D-1D88D8D514BE} key?
-- You can use the registry editor regedit.exe to open this key and export to a .REG file. Please post the text from the REG file.
This key was not found on my system..
Chuck
|
|
Thu Nov 15, 2007 11:10 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7847
|
|
|
|
Thanks. Do you have local admin privileges for the system?
In other words can you make changes in HKEY_CLASSES_ROOT part of the registry?
When you ran the setup, did you get any errors?
|
|
Thu Nov 15, 2007 1:22 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|