Post reply

SQL Server 2000 Enterprise Manager Snap-in missing

  • November 11, 2006 at 5:59 pm

    #62377

    After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 and/or repair it? Please advise. Thanks.

  • November 12, 2006 at 9:25 am

    #671244

    I had a similar issue and fixed it using this:

    various versions or instances of MS SQL Server

    you may hit the problem of

    ---------------------------

    Microsoft Management Console

    ---------------------------

    Snap-in failed to initialize.

        Name:<unknown>

        CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}

    To fix the problem,

    1. Click Start, click Run, type regedit, and then click OK.

    2. Locate the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup

    3. Right-click the ClientSetup registry subkey, point to New, and then click String Value.

    4. Rename the registry subkey that you just created SqlPath, and then press ENTER.

    5. Double-click the SqlPath registry subkey, and then type C:\Program Files\Microsoft SQL Server\80\Tools in the Value data box.

    6. Click OK, and then close Registry Editor.

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

    Got this from someones blog but can't remember who's

  • July 13, 2007 at 12:52 pm

    #719403

    Nice.... worked perfectly.

    Many Many Many Thanks

  • August 4, 2007 at 7:47 am

    #724699

    It saved me the 1-2 hours re-installation!!

    Thanks!!

     

  • August 6, 2007 at 2:40 pm

    #724942

    huh ???? 1-2 hours to reinstall the EM ??? that has to be one really sloooooow server ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • August 7, 2007 at 9:57 am

    #725226

    Or a busy one

  • October 18, 2007 at 7:56 am

    #743129

    Hey guys,

    Thanks alot for the tip. Its been really helpful!

  • October 31, 2007 at 9:41 am

    #747146

    Thank you!!!! :w00t:

  • December 4, 2007 at 1:35 pm

    #757120

    Guys Thanks for the tip you are the best!!!!:D

  • March 18, 2008 at 4:09 pm

    #791188

    Thank you very much man:D

  • June 5, 2008 at 4:02 am

    #824689

    HI..

    I am having the same problem related with EM of SQL server 2000....

    I have also tried the solution provided in this forum but its not working. Is there someone who are able to provide me the proper solution..........

    Thanks in advance!!

    Pl help!

    -Sunil

  • June 5, 2008 at 4:03 am

    #824691

    Whwn i am starting my EM following alert is coming......

    snap-in failed to initialize. name: Microsoft SQL Enterprise Manager of sql server 2000

  • July 22, 2008 at 8:40 pm

    #846773

    Thanks it works well...

    🙂

    Thanks and Regards,

    Joy

  • October 21, 2009 at 11:51 am

    #1069025

    Thanks. This worked great for me as well.

  • March 29, 2010 at 1:21 pm

    #1141665

    Thx I tried this and it worked for me ...

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply