Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 816701 - Last Review: December 3, 2007 - Revision: 4.4
Error message: OLE DB provider SQLOLEDB was unable to begin a distributed transaction
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.
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.
To work around this behavior, install network DTC access on
both servers:
- Click Start, and then click
Control Panel.
- Click Add or Remove Programs, and then
click Add/Remove Windows Components.
- In the Components box, click
Application Server, and then click
Details.
- Click to select the Enable network DTC
access check box, and then click OK.
- Click Next, and then follow the
instructions that appear on the screen to complete the installation
process.
- Stop and then restart the Distributed Transaction
Coordinator service.
- Stop and then restart any resource manager services that
participates in the distributed transaction (such as Microsoft SQL Server or
Microsoft Message Queue Server).
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
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate