Error message when you try to install a SQL Server 2005 service pack, hotfix, or cumulative update: "The Transaction Manager is not available"

Article translations Article translations
Article ID: 940971 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You cannot install a Microsoft SQL Server 2005 service pack, hotfix, or cumulative update. When this issue occurs, an error message that resembles the following is logged in the Summary.txt file:

Machine : server_name
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)

Note The Summary.txt file is located in the %ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder.

Additionally, an error message that resembles the following is logged in the SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log file:

MSI (s) (9C!38) [17:51:18:649]: Product: Microsoft SQL Server 2005 Tools -- 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 0x8013150
Error description: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)
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 0x8013150
Error description: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)

Note The SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log file is located in the %ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder.

CAUSE

This issue occurs if the SQL Server Setup program cannot access the Microsoft Distributed Transaction Coordinator (MSDTC) service.

RESOLUTION

To resolve this issue when SQL Server 2005 is installed on Windows Server 2008 R2, use one of the following methods.

Method 1
  1. Click Start, click Administrative Tools, and then click Component Services.
  2. Under Console Root, expand Component Services, and then expand Computers.
  3. Expand My Computer, and then expand Distributed Transaction Coordinator.
  4. Right-click Local DTC, and then click Properties.
  5. On the Security tab under DTC Logon Account, type NT Authority\NetworkService in the Account box.
  6. Click to select the Network DTC Access check box.
  7. Click to select the following:
    • Allow Remote Clients
    • Allow Remote Administration
    • Allow Inbound
    • Allow Outbound
    • No Authentication Required
    • Enable XA Transactions
    • Enable SNA LU 6.2 Transactions

    Note If the MSDTC service runs as a cluster resource, failover the cluster that contains the MSDTC service to each node. The changes are applied automatically to each node.
  8. Try to install the SQL Server service pack, hotfix, or cumulative update again.

Method 2
  1. Click Start, click Administrative Tools, and then click Component Services.
  2. Expand all nodes in the navigation pane.

    Note The COM+ Application Service uses the MSDTC service to populate the nodes in the navigation pane. If you can expand all the nodes in the navigation pane, the MSDTC service is in a healthy state.
  3. Create an empty application. To do this, follow these steps:
    1. Right-click COM+ Applications, click New, and then click Application.
    2. Click Next, and then click Create an empty application.
    3. Follow the prompts to create a new empty application.

    Note If you can create a new application, the COM+ System Application service and the MSDTC service are in a healthy state.
  4. Test the cluster nodes by moving the cluster resources to each node.
  5. Remove the test application that you created in step 3.
  6. Try to install the SQL Server service pack, hotfix, or cumulative update again.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about how to securely enable network access for the MSDTC service, visit the following Microsoft TechNet website:

http://technet.microsoft.com/en-us/library/cc753620.aspx

For more information about how to modify the default MSDTC resource in Windows Vista or in Windows Server 2008, visit the following Microsoft TechNet website: 
http://technet.microsoft.com/en-us/library/cc742418.aspx
For more information about how to enable firewall exceptions for the MSDTC service, visit the following Microsoft TechNet website: 
http://technet.microsoft.com/en-us/library/cc725913.aspx

For more information about how to configure authentication options in the Security Configuration tab of MSDTC, click the following article numbers to view the articles in the Microsoft Knowledge Base:
  • 969594 Windows 2003 Service Pack 2 forces Mutual Authentication with MSDTC
  • 899191 New functionality in the Distributed Transaction Coordinator service in Windows Server 2003 Service Pack 1 and in Windows XP Service Pack 2


Properties

Article ID: 940971 - Last Review: May 7, 2012 - Revision: 5.0
APPLIES TO
  • Microsoft SQL Server 2005 Service Pack 2, when used with:
    • Microsoft SQL Server 2005 Standard Edition
    • Microsoft SQL Server 2005 Workgroup Edition
    • Microsoft SQL Server 2005 Developer Edition
    • Microsoft SQL Server 2005 Enterprise Edition
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB940971

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com