MMC cannot open the file c: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ SQL Server Enterprise Manager. MSC)

Source: Internet
Author: User

Yesterday, I encountered a very strange file. SQL Server was well-used. I don't know how to suddenly see this error. I thought it was because SQL Server had missing any files and I re-installed it again, as a result, all the registries and temporary files are cleared and re-installed. The error persists. Very depressing.

The error is as follows:

---------------------------
Microsoft Management Console
---------------------------
MMC cannot open the file c: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ SQL 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.
---------------------------
OK
---------------------------

Later, search onlineArticleFinally, I found a solution and recorded it. I hope it will help my friends who encounter such problems in the future! Solution:

Start-run-input: MMC-open "file"-Add/delete snap-in-add an SQL Server snap-in = OK

Go back to the console -- option -- select "user mode full access" in Console mode -- Cancel all the following options. Finally, choose console -- save as -- Storage: C: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ SQL Server Enterprise Manager. MSC (the binn folder under the installation directory of sqlserver ).

Otherwise, register the DLL again.
Run: regsvr32 c: \ windows \ system32 \ msxml3.dll"

 

This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/elangno1/archive/2009/05/17/4194591.aspx

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.