An error occurred while installing SQL Server2005: "unable to install and configure the assembly in the COM + Directory"

The following error is reported when SQL Server2005 is installed today. The Complete error prompt is as follows:

"The assembly D: \ Program Files \ Microsoft SQL Server \ 90 \ DTS \ Tasks \ Microsoft. SqlServer. MSMQTask. dll cannot be installed and configured in the COM + Directory. Error:-2146233087.

Error message: Unknown error 0x80131501

Error Description: one or more installed components have been registered as 32-bit components in the target application. You must install the 64-bit components installed in other COM + applications, or delete the existing 32-bit components installed from the target COM + application before trying to install the 64-bit version. COM + applications cannot contain neutral-bit components ."

The solution is as follows:

Pause the installation. Do not click stop or ignore or cancel the installation.

Follow these steps:

Tip: When you delete the registry, back up the registration items to be deleted.

1. Delete the keys in the registry:

Supplement: SQLServer2005 installation prompt service cannot be started

Solution

1. enter msconfig in the command line and select 'boot. INI '-'Advanced options': Select'/numproc' and set it to the npower (2/4/8) of 2, which cannot exceed the total number of cores of the machine. Click "OK" and restart the computer to make the settings take effect. See the figure for details:

2. Install SQL Server 2005. This time there will be no errors that the service cannot be started, and it should be smooth.

3. Install Service Package 3 and SQL Server SP3 patches.

4. Enter msconfig again, open the General tab, click normal start-load all device drivers and services on the General tab, and then click OK.

5. Restart your computer.

Appendix: Microsoft SQL Server 2012 MSDN official simplified Chinese version

The latest SQL Server 2000 simplified Chinese enterprise with a registration code

Another solution

1. Enter msconfig in the command line, open the BOOT. ini tab (in English) or the guide tab (in Chinese), and select [advanced options ...], Open and set the value of processor count in the drop-down box to 1, or the value of the Numeric tab to 1. Click "OK" and restart the computer to make the settings take effect.
2. Install SQL Server 2005. This time there will be no errors that the service cannot be started, and it should be smooth.
3. Install Service Package 3 and SQL Server SP3 patches.
4. Enter msconfig again, open the General tab, click normal start-load all device drivers and services on the General tab, and then click OK.
5. Restart your computer.

• HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSDTC item
• HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSDTC item
• HKEY_CLASSES_ROOT \ CID

2. Run cmd to stop the MSDTC service: net stop msdtc.
3. Run cmd to uninstall the MSDTC service: msdtc-uninstall
4. Run cmd to reinstall the MSDTC service: msdtc-install

Finally, click retry to continue the installation.

Follow these steps to solve the problem.

PS: run CMD in winodws7. Run CMD as an administrator; otherwise, the following error is prompted:
System error 5. Access Denied.