MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance I am receiving errors when I try to run a distributed query against different SQL Server 2008 R2. At first I thought this might be cause the servers have been set up on a VM using a clone but after I discovered that I could run this query on SQL Server 2000 but it fails on a SQL Server 2008 R2 on the same server I am beginning to think that there is something I am just missing.

It does run without any issues on another developers network but it isn't running VMs

Steps I have done so far:


Totally uninstalled MS-DTC, rebooted and installed MS-DTC and another reboot.
Ran Dtcping - no errors
Checked to make sure there are no duplicate SIDs
Asked my non geek wife. She changed the subject to shopping
Rechecked the link servers - everything checks out.
Ran profiler on the transaction - no information given.
Checked the MS-DTC on production boxes to look for anything I might have missed. Also checked out from sp_configure from production boxes to look for anything that I might have missed.
uninstalled/reinstalled MSDTC just in case.
Made sure that the security on DTC isn't stopping me from doing anything.
Firewalls are off on every server I had played with.
Got caught googling MSDTC on my phone while having lunch with my wife.
Updated my servers for with any missing patches.
Talked to my dog about it. At least he listen but didn't have any answers.
Picked up everything and tried it on a different server. No change.
Read the logs from MSDTC to find out that the parent node is the one asking for the abort request
We have run into issues when servers were re-named and we had to set the DTC security properties to "No Authentication Required" on all servers involved in the transaction. This is not a best practice but works for internal network only servers. Directions to the DTC security settings can be found here: https://technet.microsoft.com/en-us/library/cc731495.aspx