Unable to install and configure assembly errors in the COM + catalog:-2146233087 workaround [measured]_mssql2005

1, sql2005 download address http://www.jb51.net/softs/2190.html Note, to download the 947M file, the wrong attention
In general, if you are prompted COM + problems in advance, do not wait for installation to the last, and then, I was resolved through the second method, and is suspended after the installation, all normal.

The first type of error appears:

Unable to install and configure assembly errors in the COM + catalog:-2146233087
Unable to install and configure assembly C:\Program Files\Microsoft SQL Server\90\dts\tasks\microsoft.sqlserver.msmqtask.dll in the COM + catalog.
Error:-2146233087
Solution to "Unable to install and configure programs in the COM + catalog" at SQL Server installation:
Cannot install and configure assemblies in the COM + catalog, C:\program Files\Microsoft SQL Server\90
\notificationservices\9.0.242\bin\microsoft.sqlserver,notificationservices.dll.
Error:-2146233087
Error message: Unknown error 0x80131501
Error Description: The transaction manager is available. (Exception from hresult:0x8004d01b)

"Solution"

At this time can suspend installation, do not click Abort, ignore, also do not click Cancel

Follow these steps
1. Delete keys in the registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
Hkey_classes_root\cid
2, use cmd execution stop MSDTC service: net stop MSDTC
3. Uninstall MSDTC service using cmd: Msdtc-uninstall
4, use CMD to perform reinstall MSDTC service: Msdtc-install
Click Retry to continue the installation.
How to handle COM + check failure during SQL Server setup

The second type of error shows:

COM + catalog requirements (warning)
Message: The COM + catalog requires that if SQL Server Setup fails, Setup will roll back the installed system, but all. manifest files may not be deleted. The workaround is to rename the files, and then rerun Setup. For more information, see how to handle COM + check failure during SQL Server setup.
When installing SQL Server 2005 to the System check configuration, I encountered the above problem, my solution is:
First of all the services with COM + enabled, and then the DTC service started (note: This service is sure to start the Oh, if there is no starting can be referred to: Distributed Transaction Coordinator service can not start the solution. Then reinstall, the mistake is resolved. In fact, you can skip the first step (the services started with COM + all enabled), as long as the DTC to start the service is no problem.
The following is an official Microsoft Solution:< How to troubleshoot COM + system configuration check failures in SQL Server setup:
Microsoft SQL Server 2005 Setup checks to see if COM + is configured correctly. If a configuration error is found, Setup will continue, but the following warning appears in the System Configuration Check (SCC) Report:
"If SQL Server Setup fails, Setup will roll back the installation that you made, but you may not delete all the. manifest files. The workaround is to rename the files, and then rerun Setup. ”
If the Microsoft Distributed Transaction Coordinator (MS DTC) is not running, or if MS DTC is not a cluster resource, a COM + error may occur if you are using a Microsoft Cluster server. COM + relies on MS DTC, whereas the Message Queue task in integration Services relies on COM +. If a COM + error occurs, the Message Queuing task in integration Services is available only if the COM + system is properly configured.
To use Message Queuing (also known as MSMQ), make sure that MS DTC is running and configured correctly. If SQL Server is installed on a cluster, MS DTC must be a cluster resource.

Follow these procedures to reinstall COM +:

One: Install Component Services snap-in

1> on the Windows desktop, click Start, and then click Run.
2> in the Open box, type MMC, and then click OK.
3> in the Console window, click Files on the menu bar, and then click Add/Remove Snap-in.
4> in the Add/Remove Snap-in window, click Add.
5> in the Add Standalone snap-in window, select Component Services from the Snap-in list, and then click Add.
6> Click Close to close the Add Standalone snap-in window, and then click OK to close the Add/Remove Snap-in window.
In the console Root \ Component Services window, expand the Component Services tree. This is where the error message can occur when COM + is having a problem.
Run SQL Server 2005 Setup again. If you receive an error message, reinstall COM +.

Two: Reinstall COM +

1> from Add or Remove Programs in Control Panel, click Add/Remove Windows components.
2> in the Windows Components Wizard, do not make any changes to the selection and click Next.
3> always click to complete the wizard, and then run SQL Server 2005 Setup again.

Unable to install and configure assembly Microsoft.SqlServer.NotificationServices.dll in the COM + catalog

An error occurred while installing SQL Server 2005, but the contents of the error dialog box were not recorded, but Summary.txt (Summary.txt is located in%programfiles%\program Files\Microsoft SQL Server\90\Setup bootstrap\log\hotfix) file contains the following information.
Machine:servername
Product:client components
error:failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\notificationservices\9.0.242\ Bin\microsoft.sqlserver.notificationservices.dll in the COM + catalog.
Error:-2146233087
Error Message:unknown Error 0x80131501
Error description:the Transaction Manager is not available. (Exception from hresult:0x8004d01b)

Microsoft offers the following solutions:
To work around this problem, make sure that distributed Transaction Service Coordinator runs the NT under Tworkservice account. To doing this, follow these steps:1. Click Start, click Run, type Services.msc, and then click OK.
2. In the Services window, double-click the Distributed Transaction Coordinator service.
3. In the Distributed Transaction Coordinator Properties dialog box, click the Log on tab.
4. On the Log on tab, specify the "NT AUTHORITY\NetworkService account to" The logon account if the logon The NT AUTHORITY\NetworkService account.

Note Your are prompted to restart the Distributed Transaction Coordinator service if the following conditions are U change the logon account of the Distributed Transaction Coordinator service.
the Distributed Transaction Coordinator service is running your change to the logon account.

5. Start the Distributed Transaction Coordinator service if it is not started.

But if an error occurs at startup and the error code is 1073337669, enter at the command prompt
Msdtc-resetlog

Note: This error occurs only if you do not select the SQL Server component when installing VS2005, and then when you install SQL Server.