dbTalk Databases Forums  

MSDTC Config

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss MSDTC Config in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Justin Rich
 
Posts: n/a

Default Re: MSDTC Config - 02-26-2008 , 09:23 AM






so I read the one about how to configure the MSDTC on 2k3 and it sounds like
it wants it own name/ip and drive. Right now im using the cluster name/ip
and the quorum drive. Dont see that as a huge problem.

The next part I was reading was how to configure MSDTC which was actually
all new to me.
This was never configured on my cluster and has yet to present a problem.
The reason I bring this up is from what I have read its a "good idea" to
have MSDTC setup for a cluster (read things that say you need it, some that
say you dont, and other recommending it).
Also I was told by the application vendor that MSDTC should be installed on
the cluster. Im going to assume since I never did the security settings that
MSDTC has never been in use.

Does the cluster use MSDTC?
Does SQL need MSDTC (DB services only, no analysis, reporting etc)

Dont have any problems, just a little confused

Thanks for all the help guys.

Justin

"Linchi Shea" <LinchiShea (AT) discussions (DOT) microsoft.com> wrote

Quote:
Some useful Microsoft resources on configuring MSDTC in a cluster:

http://support.microsoft.com/kb/290624
http://blogs.msdn.com/sqlblog/archiv...a-cluster.aspx
http://support.microsoft.com/kb/301600/

Linchi

"Justin Rich" wrote:

so although I have read a few things in both directions, it seems I need
the
MSDTC for a SQL cluster. When I create it I have to assign dependencies
to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have
any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.