RE: MSDTC on Single Node Cluster

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: Windows 2000 Server and Windows Server 2003 together with SQL 2000?
    ... SQL 2000 does not require MSDTC to function. ... MVP - Windows Server - Clustering ... I'm fuzzy on your MSDTC comments. ... Yes you do need MSDTC for a SQL Cluster. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL 2008 Installation
    ... MSDTC should be in each Cluster group for each instance of SQL (does ... You need to start with Integrted installation. ... Here are my thoughts on MSDTC and Windows 2008 clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster groups and failover
    ... There are many different theories of where MSDTC should reside. ... applied which is why it doesn't matter if it's in the Cluster Group. ... Exchange doesn't use MSDTC as oppose to SQL depending what it's ...
    (microsoft.public.windows.server.clustering)
  • Re: MS DTC service failing to start (Distributed Transaction Service)
    ... If you do not need MSDTC then you can disable it (Set to Manual if you have ... SQL, there is a good chance you will need it...check with the DBA. ... The MS DTC service was started before the cluster service on this cluster ...
    (microsoft.public.windows.server.clustering)
  • Re: W2K SQL Cluster MSDTC cannot failover
    ... There are 2 groups configured under Cluster Admin: ... , SQL Network Name, SQL Server, SQL ... Server Agent, SQL Server Fulltext; ... Group", MSDTC always fails. ...
    (microsoft.public.sqlserver.clustering)