Thursday, February 14, 2013

MMC cannot open the file SQL Server Enterprise Manager


ERROR:
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.

Solution:
Method 1: Permanent Solution 

  • Select Start -> Run.
  • At the Open prompt enter: mmc



  • Click OK
  • Select File - Add/Remove Snap-in



  • Click Add...
  • Select Microsoft SQL Enterprise Manager


  • Click Add, then Close
  • Click Ok to return to the mmc.
  • Select File - Save As...



  • Delete or rename the original (offending) file out the way.
  • 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.
Method 2: Temporary Solution
  • Right click SQL Enterprise Manager - Run as Administrator
  • Click ok to Run.


No comments:
Write Comments