我创建了 2 个节点故障转移 Microsoft 群集 Windows 2016。在节点 1 上已安装 SQL 2014 服务器群集,新角色正在运行并在群集管理控制台中处于在线状态。现在我应该将节点 2 添加到 SQL Server 群集,以便在节点 2 上切换角色,但在节点 2 上安装 SQL 2014 时我遇到了这个问题:
由于无法手动插入集群网络名称,我点击了“下一步”:
在这里可以手动插入 SQL 群集角色的 IP 地址,这就是我所做的,但是单击“下一步”设置会引发异常:“无法找到 SQL 服务器故障转移群集实例名称”作为群集资源“(错误代码 0x84C00001)。
我花了几个小时在 Google 上寻找解决方案,但没有成功。
由于集群网络名称不应为空(我认为这就是问题所在),有人可以帮助我了解如何解决这个问题吗?
谢谢
答案1
我遇到了同样的问题并再次检查了 cluster.log 文件,在其中发现了以下条目:
r <SQL Server (INSTANCENAME)>: [sqsrvres] Dependency expression for resource 'INSTANCENAME' is '([af9669ae-e2b9-4548-994f-172d5ab167ed])'
000022b0.00000958::2021/04/05-16:51:40.485 ERR [RES] SQL Server <SQL Server (INSTANCENAME)>: [sqsrvres] Unable to open the SQL Server instance registry of 'Cluster' with error: 2. Please contact customer support
000022b0.00002fc0::2021/04/05-16:51:40.486 ERR [RES] SQL Server <SQL Server (INSTANCENAME)>: [sqsrvres] GetRegKeyAccessMask: Could not get registry access mask for registry key Software\Microsoft\Microsoft SQL Server\MSSQL15.INSTANCENAME\Cluster (status 2)).
000022b0.00002fc0::2021/04/05-16:51:40.486 ERR [RES] SQL Server <SQL Server (INSTANCENAME)>: [sqsrvres] Worker Thread (1C8ECDE0): Failed to retrieve the SQL Server cluster registry key (last error = 2).
000022b0.00000958::2021/04/05-16:51:40.486 ERR [RES] SQL Server <SQL Server (INSTANCENAME)>: [sqsrvres] SQL Cluster shared data upgrade failed with error 0 (worker retval = 2). Please contact customer support
000022b0.00000958::2021/04/05-16:51:40.486 ERR [RES] SQL Server <SQL Server (INSTANCENAME)>: [sqsrvres] Failed to prepare environment for online. See previous message for detail. Please contact customer support
000022b0.00000958::2021/04/05-16:51:40.486 INFO [RES] SQL Server <SQL Server (INSTANCENAME)>: [sqsrvres] SQL Server resource state is changed from 'ClusterResourceOnlinePending' to 'ClusterResourceFailed'
000022b0.00000958::2021/04/05-16:51:40.486 WARN [RHS] Online for resource SQL Server (INSTANCENAME) failed.
由于某种原因,SQL 卸载节点安装程序错误地从路径 Software\Microsoft\Microsoft SQL Server\MSSQL15.INSTANCENAME\Cluster 中删除了一些注册表项。
当我使用健康实例作为参考重新创建它们时,我能够成功运行 SQL Server 修复向导。