Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a windows 2000 system, running Microsoft SQL server 2000, and a lot of other junk.

When I try to start the Enterprise Manager, I get the following error message.

Snap-in failed to initialize:
Name: Microsft SQL enterprise Manager
CLSID: {00100100-1816-11D)-8EF5-00AA0062C58F}

In my searches, I have come across 2 knowledge base articles that seem to match the issue, but they don't help.

http://support.microsoft.com/kb/826282/en-gb : The PATH already includes the C:\WINNT\system32\Wbem directory.

http://support.microsoft.com/kb/914157 : I don't think anyone has ever installed "Microsoft SQL Server 2005 Backward Compatibility Components", and the registry entry is correct, and I have re-registered the sqlmmc.dll file

Does anyone have any suggestions as to how I can fix this issue?

share|improve this question
    
Have you tried reinstalling Enterprise Manager? –  joeqwerty Jan 25 '11 at 13:04

2 Answers 2

up vote 0 down vote accepted

Can you login to SQL from SQL query analyzer? or cmd -> isql? I mean is the SQL engine functioning, just that you can't open the Enterprise Management console?

It could a problem on client tools and re-installing them can fix it.

share|improve this answer
    
Re-installing Enterprise manager, as specified in msdn.microsoft.com/en-us/library/aa197918(v=sql.80).aspx appears to have fixed the issue. –  Simon Callan Jan 27 '11 at 17:42

What user are you logged in with?

You don't think .. or you know nobody installed any extras? all the solutions i have googled mention installing sql2005 on the same server..

try this link

share|improve this answer
    
I'm logged into the system as our network administrator, which works perfectly for our other (supposedly identical) server.It's unlikely that anyone has installed any sql2005 stuff on this machine, as there would be no reason to, though I wouldn't swear to to. –  Simon Callan Jan 25 '11 at 11:44
    
There's an easy way to find out if anyone installed any other SQL components... Go to Add/Remove Programs and look. –  joeqwerty Jan 25 '11 at 13:04
    
There was nothing in Add/Remove that looked the slightest bit like 2005 had been installed. –  Simon Callan Jan 27 '11 at 17:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.