Summary
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.
More Information
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:
|
Rule Software |
Rule Title |
Rule description |
Product versions against which the rule is evaluated |
|
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) |
MSDTC settings not configured optimally |
The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect situations where the MSDTC is not configured properly. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. |
SQL Server 2008 |
|
SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) |
MSDTC settings not configured optimally |
The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect situations where the MSDTC is not configured properly. If you run the BPA tool and encounter a warning with the title of Engine - MSDTC settings not configured optimally, then you need to verify the MSDTC configuration settings. |
SQL Server 2012 |
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
