Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Recommended MSDTC settings for using Distributed Transactions in SQL Server
Article ID: 2027550 - View products that this article applies to.
When you start distributed transactions that involve SQL Server Database Engine as a resource, you might encounter various error messages if the MSDTC configuration is not correct. When you have more than one SQL Server involved in a Distributed Transaction, you need to make some changes to the default configuration of MSDTC for these distributed transactions to succeed.
The error messages you will encounter if you do not configure MSDTC properly are as follows:
OLE DB provider "SQLNCLI10" for linked server "linked server name" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "linked server name" was unable to begin a distributed transaction.
For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:
Collapse this tableExpand this table
You can review and update the MSDTC settings using the instructions from the following articles:
817064 How to enable network DTC access in Windows Server 2003
306212 How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server
899191 New functionality in the Distributed Transaction Coordinator service in Windows Server 2003 Service Pack 1 and in Windows XP Service Pack 2
873160 You may receive a 7391 error message in SQLOLEDB when you run a distributed transaction against a linked server after you install Windows XP Service Pack 2 or Windows XP Tablet PC Edition 2005
940971 An error message is logged in the Summary.txt file when a SQL Server 2005 service pack, cumulative update or cluster hotfix installation fails: "The Transaction Manager is not available"
If you plan to use the SQL Server with applications that start XA transactions, then you need to enable XA transaction support in MSDTC. Refer to the following topics for more information on this:
Supporting XA Transactions
Understanding XA Transactions
Article ID: 2027550 - Last Review: April 17, 2012 - Revision: 9.0