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
---------------------------

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.

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.

Please try the same method as described above. It should fix the issue. Please let us know if it doesn't help.

Did Not help, same problem occurs.

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?

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.

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

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

Followed the steps again. Initially received the "Class not registered" pop-up. I now have pop-up help, but no context menu options.

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.

In step 6, when restarting SSMS, it pops up with class not registered.

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.

-- 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

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?