Microsoft KB Archive/940971

= SQL Server 2005 Service Pack 2 installation fails, and a &quot;The Transaction Manager is not available&quot; error message is logged in the Summary.txt file =

Article ID: 940971

Article Last Modified on 8/10/2007

-

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</li></ul> </li></ul>

-

<div class="symptoms_section">

SYMPTOMS
When you install Microsoft SQL Server 2005 Service Pack 2 (SP2), the installation fails. When this problem occurs, an error message that resembles the following is logged in the Summary.txt file:

Machine :

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 under the following folder:

%ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

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 under the following folder:

%ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

<div class="cause_section">

CAUSE
This problem occurs because the SQL Server Setup program cannot access the Distributed Transaction Coordinator service.

<div class="workaround_section">

WORKAROUND
To work around this problem, make sure that the Distributed Transaction Coordinator service runs under the NT AUTHORITY\NetworkService account. To do this, follow these steps:
 * 1) Click Start, click Run, type Services.msc, and then click OK.
 * 2) In the Services window, double-click the Distributed Transaction Coordinator service.
 * 3) In the Distributed Transaction Coordinator Properties dialog box, click the Log On tab.
 * 4) On the Log On tab, specify the NT AUTHORITY\NetworkService account to be the logon account if the logon account is not the NT AUTHORITY\NetworkService account.

Note You are prompted to restart the Distributed Transaction Coordinator service if the following conditions are true:
 * 1) * You change the logon account of the Distributed Transaction Coordinator service.
 * 2) * The Distributed Transaction Coordinator service is running before you change the logon account.
 * 3) Start the Distributed Transaction Coordinator service if it is not started.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB940971

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.