Article ID: 329332 - View products that this article applies to.
This article was previously published under Q329332
When you run a distributed transaction against a linked server in Microsoft SQL Server 2000 on a computer that is running Microsoft Windows Server 2003, you may receive the following error message:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.
The problem occurs because Microsoft Distributed Transaction Coordinator (MS DTC) is not configured for network access. By default, the network access settings of MS DTC are disabled on new installations of SQL Server 2000 on computers that are running Windows Server 2003.
To resolve this problem, follow these steps:
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
306843For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/306843/ )How to troubleshoot MS DTC firewall issues
(https://support.microsoft.com/kb/871158/ )You cannot install Microsoft Office Project Server 2003 on Microsoft Windows Server 2003
Article ID: 329332 - Last Review: May 23, 2006 - Revision: 6.5