SQL Server 2000 Enterprise manager - Snap-in failed to initialize


Our SQL Server 2000 databases are hosted at our ISP.  When we created them I downloaded the trial version of 2000 to obtain the 2000 Enterprise Manager.  I recently downloaded the evaluation version of 2005.  I ununstalled it once and re-installed.  Somehow I corrupted 2000 Enterprise Manager.  When I try to start it I get:  Snap-in failed to initialize.  Name: <unknown>   CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}

Enterprise Manager starts with a message in the object explorere space: Snap-in creation failed.

I need to get Enterprise Manager up and runing as soon as possible to proceed with a data conversions.


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.

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
WaterstoneAuthor Commented:
Thanks Andy.

Tried both methods suggested and got
an error at the last step:

Click Start, click Run, type regsvr32 "Drive:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll", and then click OK.

Error is LoadLibrary("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll") failed - The specified module could not be found.

The file sqlmmc.dll is where it is supposed to be.  Any ideas?

this means that there is some other file is missing that is referenced in sqlmmc.dll.
I would completely uninstall all the 2005 components and reinstall the 2000 version.,
Sorry I can't come up with any other solution right now.

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

WaterstoneAuthor Commented:

Thanks for the help.  I restored the Binn folder and it works now.  Now to fix the sqlmanager issues.  It does not see my local machine, just my remote sql server groups.
normally it should be just the other way round :-)
ok, seems it got messed up with the reinstalling.
Did you try the fllowing?
Expand the group "Microsoft SQL Servers".
this should show at least one group below it.
Right click on this shown group and select "NEW SQLSERVER registration".
click through the wizard's first screen (the splash screen) and if you come to the List of selectable Servers, just type in the textbox (local), press "Add" and then finish the wizard.
this should bring your local SQL Server back
WaterstoneAuthor Commented:

I thnk tge problem is with SQLMangr.exe.  I had to restore it from the backup and now when I run it it seems to be disconnected from the environment - shows no services available and the local server registration is not available in the drop down, only the remote servers.

Enterprise manager sees the local registrations but canot connect because no services have been started.
WaterstoneAuthor Commented:

When I try to refresh services in SQL Services Manager I get

the network path was not found

this installation is really corrupt.
you got any possible way of accessing your data from a different workstation?
If yes, then I would backup all the data to the other machine,
uninstall SQL Server (including to delete all left files on the disk)
and completely install it again
WaterstoneAuthor Commented:

Thanks for all your help.  For now having the Enterprise manager see my remote databases is the most critical issue.  I'll work on the local issues later.  Unfortunately
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
Fonts Typography

From novice to tech pro — start learning today.