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:
provider SQLOLEDB was unable to begin a distributed transaction
following message may appear on the OLE DB provider computer:
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
- Click Start, and then click
- Click Add or Remove Programs, and then
click Add/Remove Windows Components.
- In the Components box, click
Application Server, and then click
- 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
- Stop and then restart the Distributed Transaction
- Stop and then restart any resource manager services that
participates in the distributed transaction (such as Microsoft SQL Server or
Microsoft Message Queue Server).
Article ID: 816701 - Last Review: December 3, 2007 - Revision: 4.4
- 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