August 3, 2017
Issue : Could not find any IP address that this SQL Server instance depends upon
Today we were migrating database server to new Hyper-V Virtual environment, cloning OS and cleaning-up some obsolete software, we raised an error “Could not find any IP address that this SQL Server instance depends upon”, old database had a Cluster Setup, which we are not used any more, so, we started troubleshooting
Also we found similar error after a NIC change of the Server there were issues with starting the SQL Server services and it was failing to start
Message Error
1 2 |
<u> </u>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
1 2 |
SQL Server 2012 (Standard Edition) SP2 64 bit Windows 2012 Server R2 (Cluster) |
Solution
1 2 3 4 5 6 7 8 9 |
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. |
Hope this article help you to solve similar issue.
Follow Blog at www.sqltop.com/blog/ and try SQLTop (www.sqltop.com) to review SQL Server & Oracle Database Performance.