Greg's Blog

helping me remember what I figure out

SQL 7 MMC Configuration File Missing

| Comments

Recently our SQL box crashed and after a reboot, all the services were working fine, apart from the Microsoft Management Console for SQL (Enterprise Manager). You could however still administrate the server remotely through the MMC on a workstation. The error message we got was that hte MMC file could not be found. On inspection it turned out that the file entitled SQL Server Enterprise Manager.MSC was gone. Why this happened I do not know and if anybody can shed some light on this I would be grateful. A search through Technet, did little to shed any more light on this. So what we did is copy a version of the aforementioned .MSC file that was residing on aforementioned NT workstation into <drive letter>:MSSQL7BINN on the server and that appears to have fixed the problem.