3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Appendix B: Hosting Configurations for MS DTC 144

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.

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.

MxDB for 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.