EM Console Snap-in failed to initialize

[eggy168]

I don't know what's happening the SQL Server was working no problem yesterday, but all of sudden, the MMC is not working. When I tried to open the EM, the MMC has an error message,
"Snap-in failed to initialize"
Name: <unknown>
CLSID: {00100100-1816-11d0-8ef2-00aa0062c58f}

I don't see anything goes wrong beside the MMC ~ I can open QA with the server name and all the databases list, therefore, I can do all the stuff there. Also, I have no prb open Analysis Services.

Can anyone tell me what's wrong of the MMC and how can I fix it? I hope I don't have to re-install anything since clients are working no prb in the front end.

Thank you.

 

[mrdenny]

Try reisntalling just the client tools. It shouldn't have any effect on the SQL Server. After reinstalling the client tools you'll want to reinstall what ever service pack you are using which will take the database down for about 10 minutes.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[eggy168]

Thanks Denny, I figured it out, too. However, thanks for your replied.