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?
jimbobrocksAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

becraigCommented:
First step, ping the ip to see if you get a response:
ping 10.20.30.41

Second run ipconfig /all on both computers to be sure there isn't an ip mismatch


Finally if all else checks out above, simply identify the ip addresses of both sql servers and follow the guide below to update the cluster to point to the right servers:
http://msdn.microsoft.com/en-us/library/ms190460.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.