解决mmc cannot open the file -- sqlservermanager.msc

Upon clicking on the SQL Server Enterprise Manager shortcut the following error occurs:

MMC cannot open the file C:/Program Files/Microsoft SQL Server/80/Tools/BINN/SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file.

The msc file did exist and I definately has permissions to it.  So I can only assume it some how got corrupt.

The solution to this is fairly simple... either get another copy of this file, or create one, as follows:

1. Select Start - Run.
2. At the Open prompt enter: mmc
3. Click OK
4. Select File - Add/Remove Snap-in...
5. Click Add...
6. Select Microsoft SQL Enterprise Manager
7. Click Add, then Close
8. Click Ok to return to the mmc.
9. Select File - Save As...
10. Delete or rename the original (offending) file out the way.
11. Save the new msc file as C:/Program Files/Microsoft SQL Server/80/Tools/BINN/SQL Server Enterprise Manager.MSC

Now your original shortcut should work.

Alternatively you can always access Enterprise Manager from within the Computer Management mmc.

HTH

Tim