Error:
OLE DB provider “SQLNCLI11” for linked server “xxxxxx” returned message “The partner transaction manager has disabled its support for remote/network transactions.”.
Msg 7391, Level 16, State 2, Procedure dbo.xxxxxx, Line 1 [Batch Start Line 14]
The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “xxxxxx” was unable to begin a distributed transaction.
Fix:
- Check Component Services.
- Make sure the “Enable Promotion of Distributed Transaction” is set to “False” on the linked server property.
‘remote proc transaction promotion‘ is a new option on SQL Server 2008, which allows you to control whether or not you want to enlist remote stored procedure call in a distributed transaction. When this option is off (FALSE), the local transaction will not be promoted to distributed transaction. This is how we are able to separate outer and inner transactions in a “autonomous transaction” fashion.
Sources:
https://stackoverflow.com/questions/7473508/unable-to-begin-a-distributed-transaction
Comments