OLE DB provider "SQLNCLI11" for linked server "" returned message "Cannot start more transactions on this session."

Try to do:

DISTRIBUTED TRANSACTION

Error message:

OLE DB provider "SQLNCLI11" for linked server "" returned message "Cannot start more transactions on this session."

Solution:

In order to enable the distributed transactions set:

SET XACT_ABORT ON;