[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
The Transaction Manager is not available

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

The Transaction Manager is not available.


Applies to: SQL Server 2005 Developer Edition.

 

Error Message.
 

SQL Server 2005 SP3 failed to install on a failover cluster. The following information was logged in the Hotfix.log file located on the passive node (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix):


Hotfix.log:
MSP Error: 29549 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)


Cause.

This problem occurs because the SQL Server Setup program cannot access the Microsoft Distributed Transaction Coordinator (MS DTC) service.


Solution.

We had to configure Microsoft Distributed Transaction Coordinator on the cluster.

Please visit the following link for information about how to configure MSDTC:
http://support.microsoft.com/kb/301600

Another related link:

http://support.microsoft.com/kb/940971



 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.