3.4.3 MxDB for SQL Server Installation and Administration Guide

Appendix B: Host MS DTC on a Remote Node 119
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
3. Map local logins to linked server logins:
EXEC sp_addlinkedsrvlogin
@rmtsrvname='linkedsrv'
,@useself='false'
,@locallogin=null
,@rmtuser='sa'
,@rmtpassword='*******'
4. Enable Data Access and RPC on the linked server:
exec sp_serveroption 'linkedsrv','data access','true'
exec sp_serveroption 'linkedsrv','rpc','true'