spid1001 QueryInterface failed for “DTC_GET_TRANSACTION_MANAGER_EX::ITransactionDispenser”:0x8007138f(The cluster resource could not be found

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

ISSUE: Unable to perform distributed transaction in sql linked server and event viewer captures the error like ‘ITransactionDispenser:0x8007138f(The cluster resource could not be found’.

Follow the best link which I have found on search.

 

http://sqlha.com/2013/03/12/how-to-properly-configure-dtc-for-clustered-instances-of-sql-server-with-windows-server-2008-r2/

https://www.mssqltips.com/sqlservertip/2083/troubleshooting-sql-server-distributed-transactions-part-1-of-2/

https://www.mssqltips.com/sqlservertip/2113/troubleshooting-sql-distributed-transactions-part-2-of-2/

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/45176b24-26f9-4ffc-bfdf-cb97f4737958/distributed-transactions-not-working?forum=sqldatabaseengine