MSP Error: 29549 on (SQL 2005 SP2)

A quick annotation....

Error in event viewer:
The run-time environment was unable to initialize for transactions required to support transactional components. Make sure that MS-DTC is running. (DtcGetTransactionManagerEx(): hr = 0x8004d01b)

Error displayed from SQL 2005 Service Pack 2 Setup:
MSP Error: 29549

Failed to install and configure assemblies c:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notification­services.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)


Solution:

Verify the Distributed Transaction Coordinator service status and start it if it's stopped. In a clustered environment, create a MSDT Clustered Resource.
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

0 comments: