Thursday, June 5, 2008

Solved problem: MSSQL Enterprise Manager Crashed!

Out of no reason my Enterprise Manager crashed, won't start and gives an error on MMC.exe.

MMC is Microsoft Management Console which opens a lot of Microsoft applications such as different administrative tools and enterprise manager is just one of them.

I tried opening other administrative tools (eg computer management, event viewer, services, etc.) and they are functioning well, therefore mmc.exe is not the problem but enterprise manager itself which is located at "C:\Program Files\Microsoft SQL Server\80\Tools\BINN".

Solution:
I simply deleted a corrupted file at "C:\Documents and Settings\myloginhere\Application Data\Microsoft\MMC\SQL Server Enterprise Manager".

The deleted file will be re-created again when you open and close the E.M.