Dear All,
I have sql server 2016 with 5 clustered instances on the box. We are using Local DTC for these.
currently we have DB's on 2 of these instances. But problem is MSDTC is working on only 1 instance at a time. When we reboot the server, the issue is resolved on 1 instance, but other instance gets affected.
Can anyone let me know what is the recommended way to setup DTC on cluster's so that it works on all instances.
Ex:
begin distributed transaction
select * from test
commit transaction