The RegisterAllProvidersIP SQL cluster

  • Hi, New Windows 2012 R2 cluster running SQL 2012 Sp2. Validation wizard is telling me that The RegisterAllProvidersIP = 1 for the SQL resource and it should be set to 0?

    I see this relates to multi subnet SQL clustering which I am not doing. Should I just ignore this or?

  • PretendDBA (10/27/2015)


    Hi, New Windows 2012 R2 cluster running SQL 2012 Sp2. Validation wizard is telling me that The RegisterAllProvidersIP = 1 for the SQL resource and it should be set to 0?

    I see this relates to multi subnet SQL clustering which I am not doing. Should I just ignore this or?

    This link details the following

    Create or Configure an Availability Group Listener (SQL Server)


    Tip

    When RegisterAllProvidersIP = 1, if you run the WSFC Validate a Configuration Wizard on the WSFC cluster, the wizard generates the following warning message:

    "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."

    Please ignore this message.

    Please ensure you post in the appropriate forum section in future it will help others answer your questions

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Hi Perry, I'm not sure where would be more appropriate to post this question? the SQL 2012 section doesn't have a HA section?

    This is a plain Jane two node cluster with SQL no SQL Listener service? Does this still apply?

  • PretendDBA (10/28/2015)


    Hi Perry, I'm not sure where would be more appropriate to post this question? the SQL 2012 section doesn't have a HA section?

    Well it certainly doesn't belong in the sql 2008 section 😉

    SQL 2012 would be more relevant

    PretendDBA (10/28/2015)


    This is a plain Jane two node cluster with SQL no SQL Listener service? Does this still apply?

    as the tip says, ignore the message

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply