RegisterAllProviderIP warning after clustervalidation

Question

Hi

I installed two node WSFC with W2k8R2 and MSSQL2k12SP1.
I don't use AlwaysOn! The sql cluster works fine.

After every cluster installation I run the cluster validate tool.

There was a warning I couldn't explain:

"The RegisterAllProviderIP property for network name 'Name:<network_name>' is set to 1 For the current cluster configuration this value should be set to 0."

Is it a bug of cluster cluster validate tool?

Thanks

Answer 1

No, AFAIK, its not a bug. Is this cluster is in multisubnet? After SQL Installation did you tried to enable AlwaysOn?

Please refer to this article for details around "RegisterAllProviderIP" getting change to 1:

RegisterAllProvidersIP Setting

Thanks.

---

Sohail

Answer 2

thanks for fast reply,

but I wrote above: No AlwaysOn

is neither AlwaysOn  nor  multisubnet

only 2 nics for mpio

only 1 nic team for public

only 1 nic internal (heartbeat)

all other nics are disabled (in Windows not in BIOS) or have no IP settings

It is an PURE SQL Failover Cluster like in former times with mssql2k8r2

There are no AVG-Feature enabled in sql server service tabs

Answer 3

Hi Thoma,

In a multisite cluster configuration it is acceptable to have RegisterAllProviderIP=1 to help facilitate client redirection, so we can ignore that warning.

In addition, you could apply the latest Windows Operating System Service Pack.

http://support.microsoft.com/kb/2494162
http://support.microsoft.com/kb/2531907
http://support.microsoft.com/kb/2550886
http://support.microsoft.com/kb/2552040
http://support.microsoft.com/kb/2494162
http://support.microsoft.com/kb/2524478
http://support.microsoft.com/kb/2520235

If you have any feedback on our support, please click here.

Thanks.

---

Maggie Luo
TechNet Community Support

Answer 4

Thanks Maggie,

where can I view/set/unset the option: RegisterAllProviderIP?

I couldn't find the place. I guess is an sql server option?

Regards Thomas

Answer 5

Hi Thoma,

Base on my search, to cause only the IP address that successfully comes online to be registered, run the following command:

cluster /cluster:<ClusterName> res <NetworkNameResource> /priv RegisterAllProvidersIP=0

Thanks.

---

Maggie Luo
TechNet Community Support

Answer 6

ok thanks,

is it a misspelling (slip of the tongue) in the html-report?

RegisterAllProvidersIP == RegisterAllProviderIP

Answer 7

Hi Thoma,

There should be RegisterAllProvidersIP=0 in the command. I think they are not the same.

Thanks.

---

Maggie Luo
TechNet Community Support