0x800713CF: The owner node cannot run this resource (SQL)

Question

_{Thursday, January 22, 2015 9:46 AM}

I have SQL 2012 SP2 service on 2 FC nodes of 2012 R2 servers. Everything were working fine about a year, but now my first Node got mixed up with updates and it is offline now. Problem is, that second Node cannot start SQL services By its own.

I checked/tried:

- I checked, that other services related to SQL are online.

• I chenged Node´s ownership to SQL service
• Cluster name has full Access rights to OU where all Computer record of this service are in place

The error I get: 

0x800713cf:The cluster resource cannot be brought online. The owner node cannot run this resource.

All replies (7)

_{Friday, January 23, 2015 1:30 AM ✅Answered}

Hi Yannara,

When you click on roles on the left pane, it will display roles configured on the mid pane. Click on the SQL role. Then click resources tab at the bottom of the window.You will see list of resources associated with the SQL role. Right click on each of the resources (including IP address) ->properties -> click on advanced policies tab, and select your second node as a possible owner. This must be set for all the associated resoures. When done, bring the SQL role online.

Thanks,

Umesh.S.K

_{Thursday, January 22, 2015 4:39 PM}

make sure the resource group for your SQL workload is set to allow your second node to host it

also if you did a service pack upgrade of SQL on the first node but not the second node and they are not matching you will get that error

from what I can read online though, it looks like a resource ownership problem where the second node is not set to own the required clustering resources

make sure your storage is also online and accessible

_{Thursday, January 22, 2015 5:16 PM}

Hi Yannara,

Check the second node is set as possible owner on all the SQL resources.

https://support.microsoft.com/kb/313882?wa=wsignin1.0

Thanks,

Umesh.S.K

_{Thursday, January 22, 2015 6:33 PM}

Thank you both. I´m not sure, how to to check the workload. In FC graphical GUI, both nodes are memebers in owner group, same Place where the owner order can be changed or owner can be disabled. I gone through entire FC management snap-in and didn´t find any other places or settings to go through. The article kb313882 Umesh refers, is for Server 2008, and I have 2012 R2. Command cluster res <var> name of resource</var> /listowners is not supported (there is no such command). I got first node up and running, and then SQL services were ON again, but if I shutdown first Node, SQL services will go down and won´t come up. Disk storage are online and SP level matches.

Please could you guide me step By step, how to check ownership in 2012 R2?

_{Thursday, January 22, 2015 8:53 PM | 1 vote}

I think you've already checked the ownership by the sound of it, it looks something like this:

http://cdn.petri.com/wp-content/uploads/Cluster9.jpg

are you able to failover/move the SQL resources while node 1 is on or does this issue only happen if you power off node 1?

do you have other shared resources between these clusters to test proper failover?

I would also run the cluster validation while both nodes are on and again when node 1 is off to see if everything is ok in the report

_{Friday, January 23, 2015 5:21 PM}

Right click on each of the resources (including IP address) ->properties -> click on advanced policies tab, and select your second node as a possible owner. This must be set for all the associated resoures.

Hahaa, this was it! There was one role which did not have Node2 ticked/enabled. Now this works being Node1 shut-downed. Thanks. Feeling n00bed ;)

ps. I thought it would be enough just enable both nodes on high-level, had no Idea every role has its own node owner membership.

_{Friday, January 23, 2015 5:37 PM}

Hi,

Nice to hear that issue got resolved :)

Thanks,

Umesh.S.K