<ol> <li>Goto Administration Tools -> Component Services<ol> <li>Under Services (local), start the 'Distributed Transaction Coordinator'</li> <li>Goto properties on 'Distributed Transaction Coordinator', Log On tab, make sure account is NetworkServices</li> </ol></li> <li>Under Component Services, expand to My Computer, goto properties on My Computer<ol> <li>MSDTC tab, then click Security Configuration</li> <li>Check 'Network DTC Access'</li> <li>Check 'Allow Remote Administration'</li> <li>Check 'Allow Inbound'</li> <li>Check 'Allow Outbound'</li> <li>Check 'No Authentication Required'</li> <li>Check 'Enable Transaction Internet Protocol (TIP) Transactions'</li> <li>Check 'Enable XA TRansactions'</li> <li>The Acount should be NetworkServices here also</li> </ol></li> <li>Open MSSQL Enterprise Manager, expand to localhost<ol> <li>Open Security</li> <li>Right Click Linked Servers, click New Linked Server...</li> <li>Enter each servers information, on each server</li> </ol></li> </ol>