SQL 2012 Cluster - IP Address Offline
Posted on 2014-08-25
I'm having problem with changing the IP Address of SQL node2 in Failover Cluster Manager. The IP Address of 2nd node is Offline (10.20.30.42) and it's probably right because this IP is not available anymore. I was thinking to add this IP address manually as the secondary IP of the interface but it could create some unexpected issues, so I want to find out how to change this IP via Failover Cluster Manager.
When I've tried to change this to the IP of the interface which is available (primary IP) I'm getting the error "The IP Address ' 10.20.30.41' is already used. I've tried to find out how this IP is used and I couldn't find anything until I've searched the registry.
Under HKLM> Cluster> Resources there are 2 entries with different names:
- Cluster Node 2 IP address with Address value of 10.20.30.41 in Parameters registry key
- SQL IP Address 2 (clustername) with Address -> 10.20.30.42 in Parameters registry key
For SQL node1 the same values are populated with the same IP address, so I don't understand why I cannot use the same IP.
Please let me know what's the best options to sort this out?