2k8R2 SQL Cluster problem moving node

Alexandre Takacs
Alexandre Takacs used Ask the Experts™
on
Hello

I'm having an issue with an MS SQL server 2008 cluster - I can't seem to be able to move the node.

This a pretty standard, plain vanilla active / passive setup. One node is running the SQL process while the other is in "standby".

However I can't move the active node - I have an error 0x80071398 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 have verified that the target node is indeed "clicked" as possible node. The cluster validation wizard is not reporting any error or warning.

How would I go about diagnosing this ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Go to Failover Cluster Manager
Select the cluster name
Select Calidate This Cluster from the central window.
This will run tests and report any issues that will stop the cluster working
(Warning - this can temporarily take resources offline)

Author

Commented:
ok - here is the issue:

This resource does not have all the nodes of the cluster listed as 'Possible Owners'. The group that this resource is a member of will not be able to come online on any node that is not listed as a 'Possible Owner'.

How do I make it a potential owner - can't seem to find this option in the GUI.
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooter

Commented:
You should be able to do it from the command line.

In this case, I believe it would be (from an administrator command prompt):
cluster [cluster_name] resource [sql_resource_name] /addowner:[missing_node]

Open in new window


Before and/or after, you should be able to confirm what it sees as possible owners as:
cluster [cluster_name] resource [sql_resource_name] /listowners

Open in new window

11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
hmm

C:\Windows\system32>cluster "datamtxclusterDB.mydomain.com" res
Listing status for all available resources:

Resource             Group                Node            Status
-------------------- -------------------- --------------- ------
Cluster Disk 1       DATAMTXSQL           DATAMTX_DB_12   Online
Cluster Disk 2       Cluster Group        DataMTX_DB_11   Online
Cluster IP Address   Cluster Group        DataMTX_DB_11   Online
Cluster Name         Cluster Group        DataMTX_DB_11   Online
SQL IP Address 1 (DatamtxSQL) DATAMTXSQL           DATAMTX_DB_12   Online
SQL Network Name (DatamtxSQL) DATAMTXSQL           DATAMTX_DB_12   Online
SQL Server           DATAMTXSQL           DATAMTX_DB_12   Online
SQL Server Agent     DATAMTXSQL           DATAMTX_DB_12   Online

C:\Windows\system32>cluster "datamtxclusterDB.mydomain.com" resource "SQL Server
" /listowners

Listing possible owners for resource 'SQL Server':
Possible Owner Nodes
--------------------
DATAMTX_DB_11
DATAMTX_DB_12

C:\Windows\system32>

Open in new window

In other word DATAMTX_DB_11 is listed as a possible owner but not reported as such during validation... and won't accept a node move...

Any idea ?
Professional Troublemaker^h^h^h^h^hshooter
Commented:
Go through the other four resources in the DATAMTXSQL group, and make certain each of them has a possible owner of DATAMTX_DB_11 as well.

Author

Commented:
Good catch - it was the "SQL Network Name (DatamtxSQL)" resource - never thought about it...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial