MSDTC and SQL cluster

msdtc , sql cluster

i’m going set first sql fail on cluster 2 nodes , iscsi storage using windows server 2008ee , sql server 2008.

i’m not quite sure should msdtc. have install or not? found lot of documents related windows server 2003 nothing related windows server 2008. if have use msdtc how should configure it?

could me please?

answered in newsgroups, here http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windows.server.clustering&cat=en_us_a07f36d5-b4c0-4d51-bb7b-2b4491488855&lang=en&cr=us

answer summary (by ryan s):

yes, you'll want cluster msdtc purposes of clustered sql.  don't
be intimidated because documentation says windows server 2003 or
sql 2005 or whatever.  concepts same , haven't changed
radically can't set , working properly.  in fact, in
windows server 2008, it's considerably easier accomplish.

in cluster, right-click services , applications, , choose
"configure service or application"
click "next"
select distributed transaction coordinator (dtc) , click "next"
give name (or accept auto-generated name) , enter ip address
within ip address range of appropriate network.
click "next"
select storage volume use ms dtc resource , click "next"
click "next" 1 more time confirm creation of highly available
ms dtc resource.

so easier previous procedures...give try , let
know - can it!

--
ryan sokolowski
mvp - clustering
mct, mcitp x3, mcts x7, mcse x2, ccna, ccda, bcfp

Windows Server  >  High Availability (Clustering)