Is msdtc required to be installed on the boxes in this scenario?

Is msdtc required to be installed on the boxes in this scenario?

Post by QmVu » Sun, 06 Jun 2010 12:34:02


Hi,

If a C# app. uses System.Transactions to store data in sqlserver and msmq,
and it is deployed to machine A; sqlserver is in machine B; msmq is in
machine C. is msdtc required to be installed in machine A, B, and C ?

If msdtc is required in boxes other than the sqlserver box, is there a
spearate download to install the msdtc? As my understanding is that msdtc
comes with full sql server installation, it is not a feature of Windows.

Thanks,
Ben
 
 
 

Is msdtc required to be installed on the boxes in this scenario?

Post by Geoff Scha » Sun, 06 Jun 2010 13:46:17

Ben.

No. It will be installed on the machine that requires it by the system
that needs it. So for example, MS SQL Server will install msdtc. There
is no point doing a separate install on other PCs because unless there
is SQL Server or personal web server or an application that uses it
directly on that machine, it has no purpose. Anything you install that
needs it will install it.

Geoff Schaller
Software Objectives

 
 
 

Is msdtc required to be installed on the boxes in this scenario?

Post by Erland Som » Sun, 06 Jun 2010 18:53:57

Ben ( XXXX@XXXXX.COM ) writes:

My understanding is the opposite: MSDTC comes with the OS. I checked a
virtual Win2003 machine that I use as a template, and on which there is
no SQL Server, but I could still see MSDTC in Component Services.

Geoff suggested that MSDTC comes with SQL Server, but I think that
applies to older versions of SQL Server, and most of all to earlier
versions of Windows.


--
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM

Links for SQL Server Books Online:
SQL 2008: http://www.yqcomputer.com/
SQL 2005: http://www.yqcomputer.com/
SQL 2000: http://www.yqcomputer.com/
 
 
 

Is msdtc required to be installed on the boxes in this scenario?

Post by Geoff Scha » Mon, 07 Jun 2010 12:43:17

Erland,

You could be right but you won't see a "service" in the services panel
unless you install and start something that needs it. In fact I have
never tried to question the origins of msdtc but plenty of MSDN sites
refer to it as application based rather than OS based. And yes, most of
the articles/sites are of 2005 vintage or so.

I've never had to bother working this out. Anything we have had that
employed transactions just worked so I never tried to decipher where and
what got installed.

Geoff
 
 
 

Is msdtc required to be installed on the boxes in this scenario?

Post by Erland Som » Mon, 07 Jun 2010 18:20:19

Geoff Schaller ( XXXX@XXXXX.COM ) writes:

It is running on the virtual machine I referred to in my previous post.

Furthermore, I found this is the Platform SDK documentation in
MSDN Library 2001:

The MicrosoftDistributed Transaction Coordinator (DTC) is installed
automatically when you install Microsoft WindowsXP.

I also found:

You must reinstall the DTC whenever you install MicrosoftSQL Server 6.5 or any SQL Server 6.5 service pack release. This is necessary
because SQL Server setup installs an obsolete version of the DTC that
is incompatible with Component Services on Microsoft Windows2000.


--
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM

Links for SQL Server Books Online:
SQL 2008: http://www.yqcomputer.com/
SQL 2005: http://www.yqcomputer.com/
SQL 2000: http://www.yqcomputer.com/