Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
BigSam
Starting Member
30 Posts |
Posted - 2011-09-01 : 09:42:03
|
I'm trying to upgrade a sql2k8 cluster to sql2k8 R2. (OS is W2k8 Ent.)I followed the instructions in this Microsoft article http://msdn.microsoft.com/en-us/library/ms191295.aspx.I applied the upgrade on the passive node, now, when I attempt to fail-over to this node I get an error. The action 'Move to node NodeName' did not complete. An error occurred moving the clustered service or application 'SQLService'. The operation failed because either the specified cluster node is not the owner of the group or the node is not a possible owner of the group.I checked the failover cluster manager & SQL has both servers listed as preferred owners.Any suggestions? |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-09-09 : 14:05:47
|
quote from the link you provided:quote: You have to run upgrade on each failover cluster node, starting with the passive nodes first and making your way toward the node that owns the cluster resource group.
you should also check not only the cluster but also the sql server resources for possible owners not just preferred owners--------------------keeping it simple... |
|
|
|
|
|