SQL 2000 Enterprise Manager: Snap-in failed to initialize

Expanding tree on any servers in Enterprise Manager MMC, I receive the following Error Message Box:

Snap-in failed to initialize
Name: Meta Data Service
CLSID: {1DBA4DD4-EB97-4FD2-AB80-9D0D4BA74034}

I found this workaround....

Copy the following directories from a valid installation:
C:\Program Files\Common Files\Microsoft Shared\MSDesigners98
C:\Program Files\Common Files\Microsoft Shared\Repostry


Copy C:\Program Files\Common Files\Microsoft Shared\Repostry\repodbc.dll into %systemroot%\system32

Register the following DLLs with regsvr32:
%systemroot%\system32\repodbc.dll
C:\Program Files\Common Files\Microsoft Shared\Repostry\repbrui.dll
C:\Program Files\Common Files\Microsoft Shared\Repostry\repbr.dll
C:\Program Files\Common Files\Microsoft Shared\MSDesigners98\msdt70.dll
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

5 comments:

Anonymous said...

That worked for me - thanks allot saved having to reinstall client tools then the sp.

thanks gain

Anonymous said...

I did all those steps but still I have the same problem.

Vittorio Pavesi said...

Try using filemon and regmon for missing files...

Anonymous said...

Fixed worked great. Thanks.

Anonymous said...

Vittorio, Grazie!!!

It worked like a charm!

U DA MAN!