"XACT_E_NOENLIST" error message in DTC and SQL Server (831425)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • the operating system: Microsoft Windows Server 2003

SYMPTOMS

When you try to join a distributed transaction on a computer that is running Windows Server 2003, you receive the following error message:
XACT_E_NOENLIST
This error message corresponds to the following error code (HRESULT):
0x8004D00A

CAUSE

The Distributed Transaction Coordinator (DTC) service is not enabled on computers that are running Windows Server 2003. By default, the Distributed Transaction Coordinator service is disabled on computers that are running Windows Server 2003.

RESOLUTION

To enable Distributed Transaction Coordinator on a computer that is running Windows Server 2003, follow these steps:
  1. In Control Panel, double-click Administrative Tools, and then double-click Component Services.
  2. Expand Component Services, and then expand Computers.
  3. Right-click My Computer, and then click Properties.
  4. On the MSDTC tab, click Security Configuration.
  5. Click to select all the check boxes under Security Settings.
  6. Verify that Account under DTC Logon Account is set to NT AUTHORITY\NetworkService.
  7. To apply the changes, click OK.
Modification Type:MajorLast Reviewed:1/6/2004
Keywords:kbprb KB831425 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.