Go to component Services, under Console Root expand Component Services and then browse to Computers -> My Computer -> Distributed Transaction Coordinator. Right-click Local Distributed Transaction Coordinator and then click Properties:
Go to security tab. First check the box to enable Network DTC Access and then check all four available Allow options:
• Allow Remote Clients
• Allow Remote Administration
• Allow Inbound
• Allow Outbound
Also you'll need to select No Authentication Required and uncheck enable XA Transaction
Then when you try to execute your transaction you may face the following error:
OLE DB provider "SQLNCLI10" for linked server "RND-YMAZEH" returned message "Cannot start more transactions on this session.".
Msg 7395, Level 16, State 2, Line 23
Unable to start a nested transaction for OLE DB provider "SQLNCLI10" for linked server "RND-YMAZEH".
A nested transaction was required because the XACT_ABORT option was set to OFF.
So you just need to uncomment the first line (you have to “add SET XACT_ABORT ON”) before start executing your transaction.