We had a similiar, yet different, problem between two PeopleSoft production servers. We had to configure DTC on both servers to fix the problem even though the data transfer was only occuring one way. The version of SQL Server, in this case, is immaterial.
😎