Sunday, January 28, 2007

SQL2000 Enterprise Manager not working after installing SQL2005 version in the same box

When you install both versions together, one after another and try opeining the Enterprise Manager, you may recieve a message as below


snap-in failed to initialize
Name:
CLSID: {00100100-1816-11d0-8eF5-00AA0062c58F}


Resolution
Try reregistering sqlmmc.dll
ie.regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll

-:-:-

No comments: