Home Forums SQL Server 2005 Administering CLUSTER Error: Could not find any IP address that this SQL Server instance depends upon??? RE: CLUSTER Error: Could not find any IP address that this SQL Server instance depends upon???

  • June 13, 2017 at 11:05 pm

    #1946679

    Stanley Thurman - Saturday, May 16, 2009 4:23 PM

    had the same issue but none of the above worked and the adding the HKLM parameters fix did not work either.We traced it down to someone was over zealous of security and removed the AD Service account group from the Cluster Admin security but did not add the SQL Service accounts back in.If you remove the AD Group from Cluster admin for SQL 2005, you must add the SQL Service account back in so SQL can connect and cluster can manage the resources. in this case, it couldnt read the IP parameters. makes sense since this is the first parm in the dependency chain.

    Thank you very much Stanley... this work around worked for our environment but here our team have migrated the SQL server from 2008/R2 to 2012, during migration they removed old service accounts which are used for cluster configuration have removed and used new account which are part of domain group and later they are removed from group which in turn our SQL server services are stopped while failover & failback we tried most of the option which we were aware and none worked and finally the above option what suggestion had worked however I would like to add one more point it...

    To fix above issue either we can add SQL Server service accounts to cluster administrator
    or
    Adding SID's to cluster admin
    or
    Adding doming group which SQL Server service account's which are part of it...

    Thank you much for sharing resolution with us and help...