Unable to begin a Distributed Transaction

Problem

When your application uses the distribution transaction then you may encounter below error.

Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “Linked_Server_Name” was unable to begin a distribution transaction. [SQLSTATE 42000] (Error 7391) OLE DB provider “SQLNCLI11” for linked server “Linked_Server_Name”return message “The partner transaction manager has disabled its support for remote/network transaction.”.

Solution

Step 1: You need to check if the Inbound and outbound are enabled for MSTDC service on the source server.

Go To windows search –> Open “component Services” –> Brows “Local DTC” –> Right Click on it –> Select “Properties”

Set the setting as described in the screenshot below.

MSDTC
MSDTC

 

Step 2: You need to check if the Inbound and outbound is enabled for MSTDC service on the source server.

Go To windows search –> Open “component Services” –> Brows “Local DTC” –> Right Click on it –> Select “Properties”

Set the setting as described in the screenshot below.

MSDTC
MSDTC

 

Once after setting the MSDTC, execute the below script from the source server against the linked server.

if the above query gives you the list of databases present on the target server, then the MSTDC is working fine. Else you will need to check the firewall. I will write the article on the firewall issues for MSDTC next.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *