3.4.3 MxDB for SQL Server Installation and Administration Guide

Appendix B: Host MS DTC on a Remote Node 118

Test Remote DTC

We will perform a test from each of the Virtual SQL Servers.

Test from vSQLTEST1

This test is quite simple. We are going to connect to vSQLTest1 and, from

there, we will create a linked server to vSQLTest2. “Linked server” is the

Microsoft term for a remote heterogeneous server that is registered

within the local server. Once registered, it is possible to do remote

procedure calls and access remote data from the local server. For this test,

we will invoke a transaction that will enlist the remote DTC.

1. Use Query Analyzer to connect to vSQLTest1.

2. Register vSQLTEST2 as a linked server:

EXEC sp_addlinkedserver

@server='linkedsrv'

,@srvproduct=''

,@provider='SQLOLEDB'

,@datasrc='vSQLTest2\Instance2'