On a two node Windows 2003 SQL server cluster, while running the SP 2 setup for SQL server 2005, we were getting the following error :
Error Description : MSP Error: 29549 Failed to install and configure assemblies C:\Program Files (x86)\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: MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)
On the active node of msdtc, in the Component services we found red down arrow besides My Computer node that indicates something is wrong with MSDTC. Tried to expand COM+ applications node and got the following error :
80070422 : The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
In the services.msc, we found that the COM+ system application service was disabled. Enabled it by setting it to manual. Fired up the Component services and the red down arrow went away.
We ran the setup but still got the error 0x8004D027.
Took the DTC resource offline and deleted it.
Reinstalled the msdtc service from the command prompt.
msdtc -resetlog (it will set the DTC log path to quorum disk)
Went to the cluster admin and brought the dtc resource online.
Also took the SQL resource group offline and brought it online.
Ran the setup and it completed successfully.