Invalid class string in Enterprise manager

Hi, Sorry to be cross-posting, but I'm not getting much response to this...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=807314&SiteID=1

...which I don't even think is in the right forum anyway. can anyone help?

Basically, I get a error box saying "Invalid class string" in Enterprise Manager whenever I try to run a query.

Apologies if this is the DTS-related article that you've already tried, but have you looked at this KB article? Even though you're not using DTS, the installer seems to have some problems during the upgrade to 2005. I haven't seen this issue before so I'm interested to see if this solves your problem.

http://support.microsoft.com/?kbid=912421

CAUSE

During the SQL Server 2005 installation, the support for the Analysis Services Processing task in SQL Server 2000 DTS is installed as the Msmdtsp.dll file. The Msmdtsp.dll file is not correctly registered after the SQL Server 2005 installation.

Back to the top

WORKAROUND

To work around this problem, click Start, click Run, type the following command, and then click OK:

regsvr32 "C:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll"

Thanks,
Sam Lester (MSFT)

|||

nope didn't work.

I installed the Analytical services, ran the regsvr line (which worked) but still having the same problem.

btw, I used to have some version of SQL Server 2005 installed (as part of Visual Studio 2005) but removed this, as I though this was causing the problem.

I tried a repair of Visual Studio 2005 hoping this might help, which took about an hour and the failed (twice). I can run queries through Server Explorer, so I can live with this for now, but I'd still like to have it fixed, SQL Server 2000 is a important tool for a developer!

|||

Samuel,

I got this reply on the other thread..

Please file a defect report on http://connect.microsoft.com.

I suspect one of the designer components is corrupt or missing on your machine. Can you design Views in SQL Enterprise Manager? The Open Table designer and View designer are packaged in the same component, so it would be helpful to know that.

Thanks,
Steve

I have filed a defect report

|||

Thanks for the update!

Sam