Cluster resource 'DTC' in clustered service or application 'Cluster Group' failed.

[Andrea Caldarone]

Hi all,

I've a two node cluster with Windows Server 2008 Enterprise Edition x64 (not
R2). I've quorum type "Node and disk majority" I've theese clustered
resource:

AtlanteDTC Distributed Transaction Coordinator
AtlanteFS1 A simple file server
AtlanteFS2 An other simple file server
AtlanteSQL SQL Server 2005 Standard Edition x64 SP3 cluster
configured Active-Passive

Every one our I get this tre errors in the cluster event log:

n�1
Cluster resource 'DTC' in clustered service or application 'Cluster Group'
failed.

n�2 (one second later)
Cluster resource 'DTC' in clustered service or application 'Cluster Group'
failed.

n�3 (one other second later)
The Cluster service failed to bring clustered service or application
'Cluster Group' completely online or offline. One or more resources may be
in a failed state. This may impact the availability of the clustered service
or application.

I've inspected my DTC configuration and I've discovered a situation I can't
understand.In each node of the cluster under "Component Service ->
Computer -> My Computer -> Distributed Transaction Coordinator" I have:

Local DTC
Clustered DTCs

Under Clustered DTCs I see:
Atlante
AtlanteDTC

Under "Cluster Defaul coordinator resource name" I've set MSTDC-AtlanteDTC

Please help!

[Ace Fekay [MCT]]

"Andrea Caldarone" <andrea.c...@poste.it> wrote in message
news:eAvjadvU...@TK2MSFTNGP06.phx.gbl...

This question is best suited for the Cluster newsgroups, not General. I have
cross-posted it for your convenience to the
microsoft.public.sqlserver.clustering and
microsoft.public.windows.server.clustering newsgroups.

Just check back here for responses. You can reply here, which will post
automatically to the cross-posted groups.

Ace

[Geoff N. Hiten]

What are your "application or service resource group members for the DTC
group?

What is the dependency graph for that resource.

DTC typicall fails when an underlying resource won't come online.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Ace Fekay [MCT]" <ace...@mvps.RemoveThisPart.org> wrote in message
news:%23cE0yPy...@TK2MSFTNGP05.phx.gbl...

[Andrea Caldarone]

I think it's usefuel a short story of this installation:

I've setup Windows 2008 x64 cluster, passed all validation test
I've setup the two clustered file servers
I've setup SQL Server 2005 Standard SP2 x64 (SP3 was not available)

after that I begin to note the error entry in teh registry mentioned in my
previous post. I've read a lot of documentation and I have decided to
implement a clustered DTC, but those errors doesn't disappear. To answer
your question:

AtlanteDTC has no resource
AtlanteDTC is member of AtlanteSQL

the dependency graph shows:

Cluster: Atlante
Resource: MSDTC-AtlanteDTC
Started 23/10/2009 9.28.05
Completed 23/10/2009 9.28.06

'Cluster Disk 5' has no required dependencies.
'IP Address: 192.168.0.239' has no required dependencies.
'MSDTC-AtlanteDTC' dependencies are 'Cluster Disk 5' and 'Name: AtlanteDTC'.
'MSDTC-AtlanteDTC' required dependencies are Network Name; Storage.
'Name: AtlanteDTC' dependencies are 'IP Address: 192.168.0.239'.
'AtlanteDTC' required dependencies are IP Address.

"Geoff N. Hiten" <SQLCra...@gmail.com> ha scritto nel messaggio
news:erufxo3U...@TK2MSFTNGP06.phx.gbl...

[Andrea Caldarone]

I think that cluster DTC wich fails isn't that one I've created. I think it
is a sort of "default resource" that is hidden...

[JC]

Do you have any resource dependencies on the MSDTC resource? Per article,
http://technet.microsoft.com/en-us/library/cc770748(WS.10).aspx , there are
two dependencies you require. I found this to be a problem with my
configuration in test and once I added two of the resource dependencies,
MSDTC came online.

"An MS DTC resource has the following two resource dependencies:

A physical disk resource, for example, C:

A network name resource, for example, Cluster1"

"Andrea Caldarone" wrote:

> .
>