You may receive below Failover Cluster Validation error in Validate Multiple Subnet Properties section, when generates the Failover Cluster Validation Report.
The RegisterAllProvidersIP property for network name ‘Name: <SQL Cluster Name>‘ is set to 1. For the current cluster configuration this value should be set to 0.
To resolve this issue log on to one of cluster servers and run below command first to get cluster parameter details. See the RegisterAllProvidersIP value.
Get-ClusterResource “SQL Network Name (<SQL Cluster Name>)” | Get-ClusterParameter
To change the RegisterAllProvidersIP run below command.
Get-ClusterResource “SQL Network Name (<SQL Cluster Name>)” | Set-ClusterParameter RegisterAllProvidersIP 0
Then take SQL resource offline and get back online.
Rerun the Failover cluster validation report.
Nice blogpost. I was looking for some information about this parameter and even found all necessary commands! Maybe the Stop/start-ClusterResource command would be a nice addition.
Great blog post! Thanks!
Perfect! Best regards
Excellent info.
It is really good blog !!
Thanks!