How to solve the problem that MMC cannot open the file SQL Server Enterprise Manager. MSC

Source: Internet
Author: User

Today, I forced SQL2000 to be disabled, causing the MSC to be unavailable. The database server can be started, but the Enterprise Manager cannot be opened. A prompt message is displayed.

:


It's really strange that we have never encountered such a situation.
I thought that the installation file of SQL Server was damaged, so I considered re-installing SQL Server 2000. As a result, the problem persists after installation.
I checked C:/program files/Microsoft SQL Server/80/tools/binn/SQL Server Enterprise Manager. MSC. The results are good. Why can't I find them?
There are a lot of solutions on the Internet. One by one, the result is that the following method is easy to use and recorded to prevent this problem from occurring one day.
"Start"-> "run"-> type the MMC command

The following window is displayed:

"File"-> "Add/delete Management Unit (m)" or press Ctrl + m to bring up the following window:

Click the "add" button below and select "Microsoft SQL Enterprise Manager ":

Click the Add button to close the window. The Enterprise Manager is displayed in the Add/delete Management Unit list, at the same time, click "OK" and Microsoft SQL servers will appear on "console 1.
Most
Then, select "file"-> "Save as" to save the added console to C:/program files/Microsoft SQL
Server/80/tools/binn/SQL Server Enterprise Manager. msc directory, directly overwrite the existing SQL
Server Enterprise Manager. msc file.
Now you can start the Enterprise Manager.

 

I found a complete post and shared it with you.

 

Turn: http://blog.csdn.net/taipion/archive/2009/08/01/4400842.aspx

Related Article

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.