I had the same error and used a combination of the previous suggestions to resolve this.

On the source machine (my local machine in this case) I had to allow DTC through my firewall.

I then had to configure the DTC settings (dcomcnfg.exe) and select ‘Network DTC Access’ and ‘Allow Outbound’

On the target server I had to go into the DTC settings and select ‘Network DTC Access’ and ‘Allow Inbound’.

I checked the firewall on my target server and it was already allowing DTC through.

Thanks for sharing your knowledge!

Kellie