When MicrosoftSQLServer2005 is installed, SQLSERVER2005 is uninstalled. The result is displayed in the Enterprise Manager that opens SQLServer2000. the following error message is displayed: MMC creates an unmanageable unit.
After Microsoft SQL Server 2005 is installed, SQL Server is uninstalled. The result is displayed in the Enterprise Manager that opens SQLServer2000. the following error message is displayed: MMC creates an unmanageable unit.
After searching online, the solution is as follows:
1. [start] --> [run] regedit press ENTER;
2. Find the following registry subkeys:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ 80 \ Tools \ ClientSetup;
3. If the SqlPath Program item has a value of "C: \ Program Files \ Microsoft SQL Server \ 80 \ Tools", skip to step 1;
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].