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" <> ha scritto nel messaggio
news:...
> 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]" <> wrote in message
> news:%...
>> "Andrea Caldarone" <> wrote in message
>> news:...
>>> 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!
>>
>>
>> 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
>>
>
|
Similar Threads
Linear Mode
