Error message: OLE DB provider SQLOLEDB was unable to begin a distributed transaction

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

SYMPTOMS

When you try to use Microsoft SQL Server 2000 to start a distributed transaction between linked servers that are running Windows Server 2003, you may receive the following error message:
OLE DB provider SQLOLEDB was unable to begin a distributed transaction
The following message may appear on the OLE DB provider computer:
New transaction cannot enlist in the specified transaction coordinator.

CAUSE

This behavior occurs if the Distributed Transaction Coordinator (DTS) service is disabled or if network DTC access is disabled. By default, network DTC access is disabled in Windows Server 2003.

WORKAROUND

To work around this behavior, install network DTC access on both servers:
  1. Click Start, and then click Control Panel.
  2. Click Add or Remove Programs, and then click Add/Remove Windows Components.
  3. In the Components box, click Application Server, and then click Details.
  4. Click to select the Enable network DTC access check box, and then click OK.
  5. Click Next, and then follow the instructions that appear on the screen to complete the installation process.
  6. Stop and then restart the Distributed Transaction Coordinator service.
  7. Stop and then restart any resource manager services that participates in the distributed transaction (such as Microsoft SQL Server or Microsoft Message Queue Server).

Properties

Article ID: 816701 - Last Review: December 3, 2007 - Revision: 4.4
APPLIES TO
  • Microsoft Windows Server 2003, Web Edition
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
  • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft Windows Small Business Server 2003 Premium Edition
  • Microsoft Windows Small Business Server 2003 Standard Edition
Keywords: 
kbprb KB816701

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