MMC cannot open file C:/program files/Microsoft SQL Server/80/tools/binn/SQL Server Enterprise Manager. msc Solution

SQL 2000 does not know what is going on. When the Enterprise Manager is started, "MMC cannot open the file C:/program files/Microsoft SQL Server/80/tools/binn/SQL Server Enterprise Manager. MSC "error message, which provides a solution on the network:

1. Start-run-input: MMC-open "file"-Add/delete a management unit-add an SQL Server Management Unit = OK

2. Go back to the console -- options -- select "user mode full access" in Console mode -- Cancel all the options below. 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 ).

3. If not, register the DLL again.
Run: regsvr32 C:/Windows/system32/msxml3.dll"

However, this is all nonsense because the management unit of the Enterprise Manager cannot be added to the root node during the process of adding or deleting a management unit. On the contrary, the error message "MMC Cannot initialize the management unit" is displayed. This article provides a new solution to this problem:

1. When the error message "MMC Cannot initialize Management Unit" is displayed: record its CLSID: {00100100-1816-11d0-8ef5-00aa0062c58f}, and then find the hkey_classes_root/CLSID/certificate in the registry, then find the corresponding DLL file through the CLSID, which is actually sqlmmc. DLL.

2. Use regsvr32 sqlmmc. DLL to re-register it.

3. After successful registration, you can use the above solution normally.

 

The problem is solved. Finally, you can use my enterprise manager. If someone has a similar problem or doesn't understand it, leave a message.