3.4.3 MxDB for SQL Server Installation and Administration Guide

Appendix B: Host MS DTC on a Remote Node 120

exec sp_serveroption 'linkedsrv','rpc out','true'

5. Invoke a query that requires a valid DTC (remotely hosted in this case)

to succeed. A rowcnt value should be returned from the query:

begin tran

select *

into Northwind.dbo.o1

from linkedsrv.Northwind.dbo.Orders

select @@rowcount as [rowcnt]

commit tran

6. Clean up the test by dropping the linked server:

exec sp_dropserver 'linkedsrv','droplogins'

Test from vSQLTEST2

Before we start this test, let’s induce a failover for both Virtual SQL

Servers. If our later DTC test is successful, we can also confirm that DTC

is set up properly on the backup nodes and that DTC is supported

regardless of which node is the active node.

The test procedure for this part is identical to “Test Remote DTC from

vSQLTEST1” with a few added steps.

Right click on vSQLTEST1 (hosted on QAR14S17) and select disable.

Right click on vSQLTEST2 (hosted on QAR14S31) and select disable.

Ensure that both virtual hosts fail over successfully.