I know it is recommended to cluster MS DTC, and may even be required
in a Windows 2003/SQL 2005 clustered environment, but if a person is
only deploying a single active/passive SQL 2008 cluster on Windows
2008 R2 and don't plan on doing distributed transactions, do they have
to cluster MS DTC?

Microsoft claims you don't have to have MSDTC on a cluster, but I find it
nearly impossible to run without it.

I think the SQL 2008 SP installer finally got away from needing it, but the
old SP installer certainly did.

Also, any ODBC clients require DTC to implement any transactions against a
SQL Server. (Long story on that one).

SImply put, you are far better creating it and not using it that the other
way around.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"daveberm" <david.bermingham (AT) steeleye (DOT) com> wrote