I get the below error from a SQL Server Agent Job. However, if I run the query in the job manually it works fine. Why is this? Is it just SQL Agent that requires MSDTC? I don't believe it is permissions issues as the job runs under a service account that is in sysadmin role.
Executed as user: SERVERS\quinsql_sa. The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "TestServer" was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) OLE DB provider "SQLNCLI10" for linked server "TestServer" returned message "The transaction manager has disabled its support for remote/network transactions.". [SQLSTATE 01000] (Error 7412). The step failed.
The involved versions are SQL Server 2008R2 and SQL Server 2012. The SQL Job is on the 2008R2