SQL Server2000 "MCC unable to create management unit"

Solution 1:

Run MMC and then operate. Choose Console> Add/delete management unit> Add> Find Microsoft SQL Enterprise Manager> Add> close> OK. (Note: click Add to close the management unit, don't wait for a response. If you click Add multiple times, you can see N 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 Files \ Microsoft SQL Server \ 80 \ tools \ binn \ SQL Server Enterprise Manager. MSC (the binn folder under the installation directory of sqlserver ). That's all.

Solution 2:

1. [start] --> [run] Regedit press ENTER
2. Find the following registry subkeys:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ 80 \ tools \ clientsetup
3. Right-click the clientsetup registry subitem and choose [new] --> [string value].
4. Rename the Registry subitem, create sqlpath, and then press Enter.
5. Double-click the sqlpath registry subitem and type "C: \ Program Files \ Microsoft SQL Server \ 80 \ tools" in the value data box.
6. Click [OK] and close the registry editor.
7. [start] --> [run] cmd, enter regsvr32 "C: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ sqlmmc. DLL "and then click [OK].

Note: The c: \ Program Files \ Microsoft SQL Server \ 80 \ tools path must exist in the system