Problem
MSDTC does not function when used with Windows Server.
Resolution
Ensure that you have enabled DTC on the local host server. Additionally, review the troubleshooting information in Configuration fails when BizTalk Server and SQL Server are installed on separate computers.
If you are using the DTCPing tool to troubleshoot and encounter the following transaction exception message:
WARNING: the CID values for both test machines are the same while this problem won't stop DTCping test, MSDTC will fail for this
it is because you cloned machines from the same source image.
To resolve, you must uninstall and reinstall MSDTC: