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://dba.stackexchange.com/questions/65761/security-implications-disabling-promotion-of-distributed-transaction-for-linked

https://stackoverflow.com/questions/7473508/unable-to-begin-a-distributed-transaction

Last modified: September 17, 2020

Author

Comments

Write a Reply or Comment