Newbie MSDTC question

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@.nospameclipse.co.uk> wrote in message
news:11273pop2eunj40@.news.supernews.com...
> 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
>
>
|||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@.online.microsoft.com> wrote in message
news:eHmSQLeHFHA.896@.TK2MSFTNGP10.phx.gbl...
> 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@.nospameclipse.co.uk> wrote in message
> news:11273pop2eunj40@.news.supernews.com...
>