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.
begin distributed transaction
select * from test