SQL Server cluster failover fails with Error Code: 0x80071398

SQL集群故障转移问题解决

最新推荐文章于 2022-01-30 14:44:21 发布

转载最新推荐文章于 2022-01-30 14:44:21 发布 · 3.5k 阅读

SQL Server High availability 专栏收录该内容

16 篇文章

订阅专栏

本文介绍了一个关于SQL Server 2012集群手动故障转移失败的问题及其解决方法。问题表现为无法将服务从节点3转移到节点1，并伴有错误提示。通过检查发现节点1未被列为IP资源的所有者之一，重新设置后成功完成了故障转移。

今天遇到一个问题，手动Failover SQL Cluster 到另外一台Node失败，错误：

SQL Server cluster failover fails with Error Code: 0x80071398

The operation has failed

The action 'Move' did not complete

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

原因是：IP 资源里面Possabile Node丢失了,重新加上就OK了。下面这篇文章讲的很详细： http://blogs.msdn.com/b/alexfeng/archive/2013/07/23/sql-server-cluster-failover-fails-with-error-code-0x80071398.aspx

I have installed a 3-node SQL Server 2012 failover cluster on Windows Server 2012 few days ago, and it has been running very well. Until today, I found that I could not manually failover the SQL cluster service from node 3 to node 1, and failed with the following information:

The operation has failed

The action 'Move' did not complete

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

Here is a screenshot:

The error is a bit strange to me as I can see the Node 1 was listed there when I performed the Move operation, and the cluster installation was successfully on all 3 nodes. At this point, I did some research, and found someone mentioned that the Node 1 might be not a possible owner for one or more of SQL Server failover cluster dependencies. After several clicks, I found that the failed Node 1 was not a possible owner of IP address of SQL Server virtual server name like below, once I selected it back, the failover succeeded.