SQL Server database MMC cannot open files _ MySQL

Source: Internet
Author: User
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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.