4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

5. Ensure that Use local coordinator is unchecked and, at the Remote coordinator
host name prompt, specify the remote node that is hosting DTC. Then stop the
MSDTC service from Run > services.msc > Distributed Transaction Coordinator.
6. Open SQL Service Manager (Start > Programs > Microsoft SQL Server) and
then restart the SQL Server service. This step is necessary to allow the new DTC
change to take effect.
7. Set the startup method for the Distributed Transaction Coordinator service to
Manual.
Summary
DTC is quite important in a distributed environment. It is the middle man ensuring
that all parties that participated in a transaction agree with the resulting outcome.
The transaction is guaranteed to be either 100% committed or rolled back.
Hosting DTC remotely on a dedicated node is easy to set up and use. HP PolyServe
Software for Microsoft SQL Server works quite well in this scenario and has fewer
restrictions regarding whether the hosting node is part of the same cluster that is
using it.
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 183