Normally used SQL Server Enterprise Manager suddenly encountered a problem this morning, the error is as follows:
"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. "
I thought it was caused by file damage or insufficient permissions. Then I saw it on the Internet. The specific problem was that the MMC console could not load the SQL Server Enterprise Manager program. The specific solution is as follows:
Run: regsvr32 C: Windowssystem32msxml3. dll to register the dll file
This method still exists after the test, and then try the following method:
1. Start ---> RUN ---> input mmc
2. Open "file"-"Add/delete management unit"
3. Select "independent" ---> "add" ---> select "Microsoft SQL Enterprise Manager" ---> "add"
Then you will see the SQL Server Enterprise Manager interface. OK to solve the problem.