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.


  • 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.


Last modified: September 17, 2020



Write a Reply or Comment