Open the SQL Server Enterprise Manager and a window pops up with the following content:
Error message:
"Microsoft Management Console
---------
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.
Depressed, the last minute is still good. How can this problem occur now? The Enterprise Manager cannot be opened. Baidu has been surfing the internet, and many people have encountered this situation like me. For details, see the following:
Run mmc, console-Add/delete snap-in-add-find Microsoft SQL Enterprise Manager-add-close-OK (Note: After adding, click here to close it, don't wait for a response. If you click Add multiple times, you can see n SQL enterprise managers ...), Go back to the console-options-Console mode and select "user mode full access"-cancel all the options below. Finally, choose console-Save As-storage: C: Program FilesMicrosoft SQL Server80ToolsBINNSQL Server Enterprise Manager. MSC (the binn folder under the SqlServer installation directory ).
Otherwise, register the DLL again.
Run: regsvr32 C: Windowssystem32msxml3. dll
The familiar enterprise manager came back with a simple method.