How to retrieve the Enterprise Manager from sqlserver

Source: Internet
Author: User

Open the SQL Server Enterprise Manager and a window pops up with the following content:

Error message:
"Microsoft Management Console
---------
MMC cannot open the file C: Program FilesMicrosoft SQL Server80ToolsBinnSQL Server Enterprise Manager. MSC.

This may be because the file does not exist, it is not an MMC console, or it was created using a later version of MMC. It may also be because you do not have sufficient permissions to access this file.
Depressed, the last minute is still good. How can this problem occur now? The Enterprise Manager cannot be opened. Baidu has been surfing the internet, and many people have encountered this situation like me. For details, see the following:

Run mmc, console-Add/delete snap-in-add-find Microsoft SQL Enterprise Manager-add-close-OK (Note: After adding, click here to close it, don't wait for a response. If you click Add multiple times, you can see n SQL enterprise managers ...), Go back to the console-options-Console mode and select "user mode full access"-cancel all the options below. Finally, choose console-Save As-storage: C: Program FilesMicrosoft SQL Server80ToolsBINNSQL Server Enterprise Manager. MSC (the binn folder under the SqlServer installation directory ).

Otherwise, register the DLL again.

Run: regsvr32 C: Windowssystem32msxml3. dll

The familiar enterprise manager came back with a simple method.

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.