Linked Server DTC
When run query involve transactions using Linked Server, you will need to enable Network DTC Access for MS DTC transaction on both servers. If not configured, you may receive following error message:
“The partner transaction manager has disabled its support for remote/network transactions” (if not enabled on remote server)
“The transaction manager has disabled its support for remote/network transactions” (if not enabled on the local server)
“The operation could not be performed because OLE DB provider “MSOLEDBSQL” for linked server “LinkedServer” was unable to begin a distributed transaction”
Posted by John Liu Friday, July 22, 2022