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.
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.
Once after setting the MSDTC, execute the below script from the source server against the linked server.
|
1 2 3 |
Begin distributed transaction Select [name] from Linked_server_name.master.sys.databases Commit |
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.
