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
[quoted text, click to view] "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/default.asp?url=/library/en-us/architec/8_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.aspx?scid=kb;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.aspx?scid=kb;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
>>
>>
>>
>
>
