Month: January 2017

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’.

Dear Visitors!
To get Best Deals and Discounts Buy Now from Amazon just by
Clicking This Image

Simply send snap of your product details after delivery at ad22092012@gmail.com for more surprises or additional discounts

 

Follow the best link which I have found on search.

How to Properly Configure DTC for Clustered Instances of SQL Server (Revised)

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