MS Design Tools Class Not Registered

I wanted to create a diagram of the tables in my database and their relationships to each other.  In order to do that I went to Enterprise Manager, Diagrams, right click: "New Database Diagram..." but I get hte following error?:

An unexpected error happened during thies operation
[MS Design Tools] - Class Not Registered

Can you guys help me fix this?  I really need that diagram, the table has over 20 page, it take me forever do it myself...
Gemini532Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gemini532Author Commented:
Not to mention that there's at least 30 databases here and they're all pretty big...
wolffy18Commented:
does it work in another database, like pubs?  IF not then it is the instalation, version, of the SQL server. IF it does work in Pubs: do a database object dump into a text file with all objects and relationships. then create a new database and run the script, even though their is no data, you will be able to play with the diagram functions.
Gemini532Author Commented:
I think it's version 8
I went to query analyzer and I looked under help> about and it says:
Version SQL 8.00.194



OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Anthony PerkinsCommented:
You are using SQL Server Version 2000 RTM (without any service packs).  I suggest you update to the latest Service Pack 4 which you can download here:
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

This is not directly related to your problem (unregistered or corrupt dlls), but may fix it for you.
Anthony PerkinsCommented:
You can confirm the version on the server as follows:
SELECT @@VERSION, SERVERPROPERTY('ProductLevel')
Gemini532Author Commented:
>> acperkins SELECT @@VERSION, SERVERPROPERTY('ProductLevel')
I got:
Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)       SP4

So version 8, service pack 4    :)

Gemini532Author Commented:
No it does now work in PUBS
Gemini532Author Commented:
I have to re-install the SQL Server?
Anthony PerkinsCommented:
>>So version 8, service pack 4    :)<<
No. version 8 ==> SQL Server 2000 (Question: What version do you think SQL Server 7 (the version prior to SQL Server 2000) used? )

If you say your SQL Query Analyzer is using SQL 8.00.194 that means it is the RTM version. So I would suggest you update the client components with SP4 to match server.

>>I have to re-install the SQL Server?<<
I don't see why, but if you feel it is necessary, go for it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gemini532Author Commented:
>>acperkins, thank you for the helpful suggestion.
I will try that...
It will be much faster, am I right? To update the client components with SP4 to match server?

If I have to re-install the SQL SERVER, if everything goes right, how long do you think it will take?
Probably at least an hour?  OR two?
Do you know, it would be very helpful for me... because I do have the option of using another computer to make the diagrams and that's the only thing that doesn't work... It might not be worth spending a very long time trying to fix my own computer... It's true that using another computer, would mean asking the person using it, if I can use it for a few minutes, and they might say no... Still it would help if I knew how long it usually takes to re-install this server....
Anthony PerkinsCommented:
>>It will be much faster, am I right? To update the client components with SP4 to match server?<<
Sure.

>>If I have to re-install the SQL SERVER, if everything goes right, how long do you think it will take?
Probably at least an hour?  OR two?<<
The installation, does not take more than 10 minutes.  But to restore your databases, that is another matter entirely.

The bottom line, is that it is not necessary to re-install the server (and I am not even sure it would make any difference).  First try updating the client components on the workstation that is causing you grief.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.