What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster?
Cluster is already setup and virtual sql instance running ok...

Thanks

MSDTC or the Microsoft Distributed Transaction Cordinator is used for
distributed transactions.
A good description of it can be found in SQL Server Books Online:
http://msdn.microsoft.com/library/de...ar_cs_321x.asp

As you can see in the following article; MS DTC is not required for the
clustered SQL Server to work:
http://support.microsoft.com/default...b;en-us;260758

However if you have it installed on your server you need to run it in a
clustered state as you can see in the following article:
http://support.microsoft.com/default...b;en-us;301600

Simon
This posting is provided "as is" with no warranties and confers no rights.

"Lapchien" <ccarswell (AT) nospameclipse (DOT) co.uk> wrote

While we are on the subject of MSDTC within a SQL Cluster, Simon has
referred to the standard (in my mind superficial) documentation on MSDTC, I
am looking for more detailed information:
1. The detailed architecture and how a transaction enlists target
databases.
2. How the authentication and permissions work for MSDTC in detail
(e.g.. why Cluster permissions are required for services enlisting MSDTC in
a cluster).

I have configured several high-availability applications requiring
distributed transactions and fully understand the requirements for
successfully implementing MSDTC/SQL, however I would like to understand the
internal operations of MSDTC.

Regard

Gary Hope

"Simon Lidberg [MSFT]" <simonlid (AT) online (DOT) microsoft.com> wrote