Linked Server Selection Query Fails with "MS DTC has stopped this transaction"

Hi everyone,  I’m currently setting up a Linked Server from our head office (server A) SQL Server to a subsidiary unit (Server B) SQL Server. The Linked Server connection tests successfully, and I c...