Snap-in failed to initialize, Name Microsoft SQL Enterprise Manager: CLSID : {00100100-1816-11D0-8EF5-00AA0062C58F}
Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above.
On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error:
Snap-in failed to initialize
Name Microsoft SQL Enterprise Manager
CLSID : {00100100-1816-11D0-8EF5-00AA0062C58F}
Tried the undocumented method by deleting the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MMC\SnapIns\{00100100-1816-11d0-8EF5-00AA0062C58F}
For a while the tools has worked perfectly, again after applying Service pack 2 for SQL 2005 tools again struck with problem. SImilar problem on other client's machines too and I was not prepared to uninstall and reinstall the client tools. Then as a final frontier performed the method by renaming the following file on the troubled machines and copy the same file from the other machine where the problem hasn't occurred:
C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
Further information can be found from the KBA914157 article, as there are few issues on backward compatibility components.