SQL Server Enterprise Manager, which I usually use normally, suddenly had a problem this morning. The error is as follows:
"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 was created with a later version of MMC. It could also be that you do not have sufficient permissions to access this file. "
At first, I thought it was caused by file damage or insufficient permissions. Later, I saw on the Internet that it was not the above problem. The specific problem was that the MMC console could not load the SQL Server Enterprise Manager program. The specific solution was as follows:
Run: regsvr32 C:Windowssystem32msxml3.dll to register the dll file
After trying this method, the problem still existed. Then I tried the following method:
1. Start--->Run--->Enter mmc
2. Open "File" - "Add/Remove Snap-in"
3. Select "Stand-alone" ---> "Add" ---> select "Microsoft SQL Enterprise Manager" ---> "Add"
At this time you will see the SQL Server Enterprise Manager interface. OK, so the problem is solved.
This article comes from the CSDN blog. Please indicate the source when reprinting: http://blog.csdn.net/boboo_2000_0/archive/2009/12/21/5045880.aspx