How to change Cluster IP of SQL server with FCI

(0919)小林智之 61 Reputation points
2022-07-27T11:24:50.58+00:00

Server A and Server B in a domain environment are clustered in a Windown Server Failover Cluster (WSFC).
After that, SQLServer is constructed on WSFC with Failover Cluster Instance (FCI).

Versions:
WindowsServer 2019 StandardEdition
Microsoft SQL Server 2019 Enterprise

In this state, we would like to change the IP address for cluster access and the IP address assigned to FCI.

Question1:
Is it possible to change the IP address for cluster access after constructing the cluster?
 If possible, is there a manual that describes the procedure?

Question2:
Is it possible to change the IP address assigned to FCI?
 If possible, is there a manual that describes the procedure?

Question3:
In making the above two changes, if there is something that requires attention (such as reconfiguring the cluster)
 Could you please teach me?

Windows for business Windows Client for IT Pros Directory services Active Directory
Windows for business Windows Server User experience Other
SQL Server Other
{count} votes

Accepted answer
  1. Bjoern Peters 8,921 Reputation points
    2022-07-27T11:58:32.4+00:00

    Yes, you can change all IP addresses of that cluster.

    Changing the nodes IP is a standard Windows procedure
    Changing the IP address of the cluster => failover cluster manager - properties of the windows cluster
    Changing the IP address of the resource group => failover cluster manager - roles - properties of the resource

    make sure that all new IP addresses also be shown in the SQL configuration manager - network configuration

    Here is documentation on how to change SQL IPs, maybe that helps
    https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/change-the-ip-address-of-a-failover-cluster-instance?view=sql-server-ver16#WSFC

    Edit:
    Maybe - take care of your DNS server - check there if all names are pointing to the new addresses


1 additional answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,586 Reputation points
    2022-07-28T02:46:10.553+00:00

    Hi @(0919)小林智之 ,

    In addition to the information provided by BjoernPeters, you can also take a look at this article, which contains some screenshots.
    https://www.mssqltips.com/sqlservertip/4220/change-the-virtual-ip-address-for-a-sql-server-failover-cluster/
    Hope this would give you some help.

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.