Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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:
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:
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.

↑ Back to the top

Cause

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

↑ Back to the top

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.


↑ Back to the top

Status

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

↑ Back to the top

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


↑ Back to the top

Keywords: kbsql2005error, kbexpertiseadvanced, kbtshoot, kbprb, kbentirenet, kb

↑ Back to the top

Article Info
Article ID : 940971
Revision : 3
Created on : 11/20/2019
Published on : 11/20/2019
Exists online : False
Views : 522