What configurations do I need to fix the "unable to begin a distributed transaction" error when trying to run a remote procedure? This is the error message I'm receiving:


  Msg 7391, Level 16, State 2, Procedure spStoredProc, Line 62 [Batch Start Line 1]
  The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "MyLinkedServer" was unable to begin a distributed transaction.


As a test my stored procedure query is just SELECT 1 AS A and works locally on the server but doesn't work when I call it remotely on a linked server.
On the Linked Server properties have you tried setting "Enable Promotion of Distributed Transactions" to False?