[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2012 Cluster - IP Address Offline

Posted on 2014-08-25
1
Medium Priority
?
353 Views
Last Modified: 2015-04-10
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?
0
Comment
Question by:jimbobrocks
1 Comment
 
LVL 29

Accepted Solution

by:
becraig earned 1500 total points
ID: 40284692
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question