Link to home
Start Free TrialLog in
Avatar of jimbobrocks
jimbobrocks

asked on

SQL 2012 Cluster - IP Address Offline

Hi,
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?
ASKER CERTIFIED SOLUTION
Avatar of becraig
becraig
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial