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.
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.