SQL Error - MMC cannot open the file

MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. Upon clicking on the SQL Ser...

MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.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.

Alternate Method

at command-line:

RegSvr32 MSXML.DLL
RegSvr32 MSXML2.DLL
RegSvr32 MSXML3.DLL 

or

regsvr32 C:\Windows\system32\msxml.dll

regsvr32 C:\Windows\system32\msxml2.dll

regsvr32 C:\Windows\system32\msxml3.dll