Freigeben über

Could not find any IP address that this SQL Server instance depends upon

  • Artikel

Problem Description: 

After a NIC change of the Server there were issues with starting the SQL Server services and it was failing to start. The error it was throwing was:

Error:
Could not find any IP address that this SQL Server instance depends upon.  Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available.  Error code: 0x6d9

Environment
SQL Server 2005 (Enterprise Edition)  SP2 64 bit
Windows 2003 Enterprise Server  SP 2 
NO CLUSTER

Resolution:

Ø The error message looked like the SQL Cluster Name’s IP address was not found
Ø But surprisingly we got to know that the SQL is not on a Cluster
Ø Checked the Cluster Services”: Not present. Cluster admin not configured
Ø Question is So how are we picking the Cluster Information for SQL then..
Ø I went ahead and checked the registry and there was it, we had the Cluster key present with a Virtual SQL Server Name {which is the same as the name of the windows machine}, this key should be only present if you have a Cluster not in a Standalone Machine
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.1\Cluster {this key was existing}
Ø This can be because of someone might have tried to install SQL as a Cluster resource
Ø We deleted the Cluster key and then we were able to start the SQL Server Services from the Services.msc without any issues.

Comments

  • Anonymous
    August 19, 2010
    Thanks, I have a cluster that couldn't start on one node only with this same error message, the instance name had recently changed but this key wasn't updated on all nodes.  Updating the key fixed it nicely.

  • Anonymous
    May 05, 2012
    Thanks for this.  This works on SQL 2008R2 as well.

  • Anonymous
    July 21, 2014
    After adding the InstanceName and VirtualServerName and Cluster Resources were initially deleted, the sql resource was recreated as service rather than executable. delete, redo as executable. It works.