SQL Server retrieves the method of Enterprise Manager _mssql

Source: Internet
Author: User
Open SQL Server Enterprise Manager, and suddenly a window pops up, which reads:

Error Tip:
The Microsoft Management Console
—————————
MMC cannot open file C:Program filesmicrosoft sql Server80toolsbinnsql Server Enterprise manager.msc.

This may be because the file does not exist, is not an MMC console, or is created with a later version of MMC. It may also be because you do not have sufficient permissions to access this file.
Depressed, a minute before the good, how now appear such a situation, can not open Enterprise Manager. Internet Baidu A bit, there are many people like me to encounter this situation. See below for details:

Run MMC, console – Add/Remove Snap-add – Find Microsoft SQL Enterprise Manager – Add – Close – OK (Note: Click here to add after you can close, do not wait for response, if you repeatedly click on the add, then you can see more than n SQL Enterprise Manager ... And then back to the console – Options – Console mode Select "User mode full Access" – Cancels all of the following selections. Finally, save as – from the console – Save as: C:Program FilesMicrosoft SQL Server80toolsbinnsql Server Enterprise Manager.msc (that is, the Binn folder under the installation directory of SQL Server).

If it doesn't work, re-register the DLL

Run: regsvr32 c:windowssystem32msxml3.dll

Simple way, the familiar Enterprise Manager is back again.
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.