Article ID: 816701 - View products that this article applies to.
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:
The following message may appear on the OLE DB provider computer:
OLE DB provider SQLOLEDB was unable to begin a distributed transaction
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:
Article ID: 816701 - Last Review: December 3, 2007 - Revision: 4.4
Contact us for more help
Connect with Answer Desk for expert help.