Cluster service is attempting to failover the cluster resource gro

Praful Varsani

unread,

Mar 8, 2010, 7:46:01 AM3/8/10

to

The SQL cluster is not failover over to another node. Can anyone shed some
light in to this. I have checked the config on the cluster administrator side
and it all seems correct to me. The event id appeared is 1153 event source:
clussvc.
In theory the cluster is not working if a disaster happens. A manual reboot
is required to bring everything up to normal. Please advise.

Geoff N. Hiten

unread,

Mar 8, 2010, 8:27:13 AM3/8/10

to

Are you able to move any group from node to node?

If so, then which group will not move?

Also, please advise which versions of SQL and Windows you are using.

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

"Praful Varsani" <Praful...@discussions.microsoft.com> wrote in message
news:12A59E16-67A3-4182...@microsoft.com...

Praful Varsani

unread,

Mar 9, 2010, 6:31:01 AM3/9/10

to

Hvent done that. Need to do this during the maintenance window.

To test the failover this was carried out

Attempted to fail over from node 2 to node 1. Failover is unsuccessful.

Both Nodes were shutdown. Node 2 started first. The node 1 was started. SQL
Databases is now le on node 2.

SQL Server ENT V9.00 4035.00
Windows server 2003 R2 ENT

Well there was a issue with the switch that was conncected to the NIC cards
and should have failed over to another node.

"Geoff N. Hiten" wrote:

> .
>

Geoff N. Hiten

unread,

Mar 9, 2010, 9:18:42 AM3/9/10

to

If a node is in shutdown, it will not accept new groups.

If a network switch fails and the cluster is segmented, no failover occurs
since (a) the cluster cannont communicate the failover requests and (b)
there is no node that can accept support the IP address resource(s).

In short, it appears the cluster is behaving normally.

You definitely need to test your failover scenarios before putting the
system into production so you know what failures are capable of being
handled by clustering.

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

"Praful Varsani" <Praful...@discussions.microsoft.com> wrote in message

news:65D57187-CCB3-47BF...@microsoft.com...

Praful Varsani

unread,

Mar 9, 2010, 10:24:01 AM3/9/10

to

what do you recommend for failover scenarios

"Geoff N. Hiten" wrote:

> .
>

Geoff N. Hiten

unread,

Mar 9, 2010, 10:38:20 AM3/9/10

to

Test every likely scenario to see what happens. NIC failures, HBA failures,
unplug a server, kill the switch. I usually do this with the SQL services
offline and just a dummy disk/IPaddress/Name resource group.

Se what triggers a failover and what does not.

Clustering alone will not give you High Availability. You need People and
Process to complement the Technology.

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

"Praful Varsani" <Praful...@discussions.microsoft.com> wrote in message

news:745610AB-290F-4CC3...@microsoft.com...

Praful Varsani

unread,

Mar 9, 2010, 11:35:01 AM3/9/10

to

Are there other options to check failover other than manual failovers//

"Geoff N. Hiten" wrote:

> .
>

Geoff N. Hiten

unread,

Mar 9, 2010, 12:36:28 PM3/9/10

to

I usually move all disk resources to all nodes before installing SQL, just
to make sure everything works smoothly.

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

"Praful Varsani" <Praful...@discussions.microsoft.com> wrote in message

news:78EB32AB-513D-4531...@microsoft.com...

Praful Varsani

unread,

Mar 10, 2010, 5:39:02 AM3/10/10

to

sure...Can you elaborate more onhow would you move all the disk resources
example, go to resources, select the disks etc etc

"Geoff N. Hiten" wrote:

> .
>

Geoff N. Hiten

unread,

Mar 10, 2010, 10:46:37 AM3/10/10

to

Um. Right click on the group - "Move Group"

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

"Praful Varsani" <Praful...@discussions.microsoft.com> wrote in message

news:0B59294F-6B7C-4BD8...@microsoft.com...

Praful Varsani

unread,

Mar 16, 2010, 8:09:01 AM3/16/10

to

the cluster service account, what rights do they require to authenticate
against a domain controller

i thought local admin for that server and server operator....is this correct
if not please update me

"Geoff N. Hiten" wrote:

> .
>

Praful Varsani

unread,

Mar 16, 2010, 8:07:01 AM3/16/10

to

cluster service account, what rights do they require?

I was on the impression they need to belong too local admin group and server
operator group
Is this correct..?

"Geoff N. Hiten" wrote:

> .
>

Geoff N. Hiten

unread,

Mar 16, 2010, 8:59:54 AM3/16/10

to

Clustering in Windows 2008/2008 R2 does not require service accounts. The
Clustering service is automatically set up to run under the machine's
Network Service account. This is automatic and does not require any
additional setup steps.

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

"Praful Varsani" <Praful...@discussions.microsoft.com> wrote in message

news:5FC1C7CB-8A01-4B3A...@microsoft.com...