SQL 2012 Cluster - IP Address Offline

Posted on 2014-08-25
Last Modified: 2015-04-10
I'm having problem with changing the IP Address of SQL node2 in Failover Cluster Manager. The IP Address of 2nd node is Offline ( 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 '' 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 in Parameters registry key
- SQL IP Address 2 (clustername) with Address -> 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?
Question by:jimbobrocks
    1 Comment
    LVL 28

    Accepted Solution

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

    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:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Here's a useful script that will automatically delete ALL user profiles that are on a Windows Server 2008/R2 computer.   WARNING! This is a dangerous operation, designed for use by an administrator who needs to do a complete purge; for instance a…
    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 walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now