RE: MSDTC on Single Node Cluster

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Rupart,

If you are distrubuting transactions from the stand-alone single node SQL
Cluster to another SQL server on the domain, then Yes you will need to
install MSDTC as a resource in the Cluster.

Otherwise, you don't need MSDTC for anything.

--------------------
Hope this helps,
Mike Rosado
Windows 2000 MCSE + MCDBA
Microsoft Enterprise Platform Support
Windows NT/2000/2003 Cluster Technologies

====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
<http://www.microsoft.com/info/cpyright.htm>

-----Original Message-----
--------------------
> Thread-Topic: MSDTC on Single Node Cluster
> thread-index: AcX+vUCKgv6aZn6jQguRzWY7jBR0Kg==
> X-WBNR-Posting-Host: 192.198.147.96
> From: =?Utf-8?B?cnVwYXJ0?= <rupart@xxxxxxxxxxxxxxxxxxxxxxxxx>
> References: <19057EFE-A45D-4FDA-A923-ADEAC107C98D@xxxxxxxxxxxxx>
<W7nAdFN$FHA.1240@xxxxxxxxxxxxxxxxxxxxx>
> Subject: RE: MSDTC on Single Node Cluster
> Date: Sun, 11 Dec 2005 17:42:03 -0800
> Lines: 41
> Message-ID: <2AB369DC-6D0A-4FFB-9A00-C9CC158213E5@xxxxxxxxxxxxx>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.windows.server.clustering
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.windows.server.clustering:12607
> X-Tomcat-NG: microsoft.public.windows.server.clustering
>
> yeah..it will be single node cluster with SQL on it. Will i still need
it?
> Well, any reason why?
>
> "Mike Rosado [MSFT]" wrote:
>
> > Hi Rupart,
> >
> > Only time you need MSDTC installed on a Cluster as a resource, is
either
> > when SQL, Exchange or a particular application installed requires it.
If
> > it's a File Share and/or a Print Cluster, then MSDTC is not needed.
> >
> > --------------------
> > Hope this helps,
> > Mike Rosado
> > Windows 2000 MCSE + MCDBA
> > Microsoft Enterprise Platform Support
> > Windows NT/2000/2003 Cluster Technologies
> >
> > ====================================================
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > ====================================================
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > <http://www.microsoft.com/info/cpyright.htm>
> >
> > -----Original Message-----
> > > From: <rupart@xxxxxxxxxxxxxxxxxxxxxxxxx>
> > > Subject: MSDTC on Single Node Cluster
> > > Date: Fri, 9 Dec 2005 01:44:02 -0800
> > >
> > > Hi,
> > > Do i need MSDTC on single node cluster? Logically, i think i dont
since
> > the
> > > server will not be communicating with others. But, would like to get
> > > assurance. Am i right?
> > >
> > > TIA
> > >
> >
> >
>

.

Relevant Pages

  • Re: SQL 2008 Installation
    ... As long as the instance count is less than 2x the node count, ine MSDTC per ... you will get better resource ... But in a cluster with more than one SQL instance makes sence to have one ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Cluster and MSDTC
    ... Principal SQL Infrastructure Consultant ... MSDTC and that appears to be a fairly complicated process for a humble DBA. ... When clustering SQL on Windows 2003 you have to first cluster MSDTC ... profiler and I can't find any applications that use distributed transactions, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Cluster and MSDTC
    ... If you have more than twice the instances as you have nodes, then local MSDTC is good. ... Principal SQL Infrastructure Consultant ... article talks about using a local DTC in a failover cluster. ... >>> coordinate distributed transactions to ensure consistent updates ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 Installation
    ... But in a cluster with more than one SQL instance makes sence to have one ... MSDTC per SQL Cluster Instance, or have only one MSDTC in a dedicated ... resource local to the instance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 Installation
    ... As long as the instance count is less than 2x the node count, ine MSDTC per Instance is a good setting. ... you will get better resource management with one MSDTC instance per node. ... But in a cluster with more than one SQL instance makes sence to have one ...
    (microsoft.public.sqlserver.clustering)