SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Beta in SSMS Add-In Failure - Class not registered
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Beta in SSMS Add-In Failure - Class not registered
Author Message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Beta in SSMS Add-In Failure - Class not registered Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
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 View user's profile Send private message
ChuckR80010



Joined: 13 Nov 2007
Posts: 4
Country: United States

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
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 View user's profile Send private message
ChuckR80010



Joined: 13 Nov 2007
Posts: 4
Country: United States

Post Reply with quote
Did Not help, same problem occurs.
Tue Nov 13, 2007 11:56 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
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 View user's profile Send private message
ChuckR80010



Joined: 13 Nov 2007
Posts: 4
Country: United States

Post Reply with quote
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 View user's profile Send private message
jamiesw



Joined: 13 Nov 2007
Posts: 1

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
In step 6, when restarting SSMS, it pops up with class not registered.
Wed Nov 14, 2007 10:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
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 View user's profile Send private message
ChuckR80010



Joined: 13 Nov 2007
Posts: 4
Country: United States

Post Reply with quote
-- 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
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 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
Goto page 1, 2  Next
Page 1 of 2

 
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.