Today, my SQLServer2000 suddenly becomes unavailable. the database server can be started, but the enterprise manager cannot be opened. the prompt message is displayed: MMC cannot open the file C: ProgramFilesMicrosoftSQLServer80ToolsBinnSQLServerEnterprise. today, my SQLServer 2000 suddenly becomes unavailable. the database server can be started, but the enterprise manager cannot be opened. a prompt message is displayed:
"MMC cannot open the file C: \ Program Files \ Microsoft SQL Server \ 80 \ Tools \ Binn \ SQL Server Enterprise Manager. MSC. It may be because the file does not exist, not an MMC console, or it was created in a later version of MMC. It may also be because you do not have sufficient permissions to access this file ."
Is it possible to reinstall SQLServer and finally find a solution on the Internet:
1. open the Run dialog box and enter: mmc
2. console -- add/delete a management unit -- add -- find Microsoft SQL Enterprise Manager -- add -- close -- OK
3. choose console> option> console mode> user mode> cancel all the following options.
4. console -- save as -- Storage: C: \ ProgramFiles \ MicrosoftSQLServer \ 80 \ Tools \ BINN \ SQLServerEnterpriseManager. MSC, that is, overwrite the existing SQL Server Enterprise Manager. MSC file
OK. the console is successfully restored!