?
Solved

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

Posted on 2006-04-06
9
Medium Priority
?
9,363 Views
Last Modified: 2013-12-03
Hello,

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.

Thanks,
Steve

0
Comment
Question by:Waterstone
  • 5
  • 4
9 Comments
 
LVL 7

Accepted Solution

by:
IT-Schubertz earned 2000 total points
ID: 16390728
0
 

Author Comment

by:Waterstone
ID: 16391167
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?
0
 
LVL 7

Expert Comment

by:IT-Schubertz
ID: 16391313
Hi,

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.

Andy
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:Waterstone
ID: 16391515


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.
0
 
LVL 7

Expert Comment

by:IT-Schubertz
ID: 16391886
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
0
 

Author Comment

by:Waterstone
ID: 16392231

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

Author Comment

by:Waterstone
ID: 16392349

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

the network path was not found

0
 
LVL 7

Expert Comment

by:IT-Schubertz
ID: 16392527
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
0
 

Author Comment

by:Waterstone
ID: 16392638

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
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question