Newbie MSDTC question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lapchien - 28 Feb 2005 21:37 GMT

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

Reply to this Message

Simon Lidberg [MSFT] - 28 Feb 2005 22:13 GMT

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_c
s_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.

> 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

Reply to this Message

Gary Hope - 28 Apr 2005 22:27 GMT

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

> MSDTC or the Microsoft Distributed Transaction Cordinator is used for
> distributed transactions.
[quoted text clipped - 16 lines]
>>
>> Thanks

Reply to this Message