4

We have two nodes in an Always On availability group, on SQL Server 2014 Enterprise.

We need to change the IP addresses of the nodes, the cluster, and the listener.

They will still remain in the same domain.

The subnet mask shall remain the same.

All will the be the same except the IP Addresses and the default gateway.

What are the steps to accomplish this?

2
  • 1
    This , this and this will help. May 23, 2017 at 18:07
  • Sorry my 3rd link is not relevant and I cannot edit a comment after certain time. You rather consult this link. May 24, 2017 at 2:12

1 Answer 1

4

Use the following steps to change IP address of the listener

ALTER ENDPOINT [MyEndpoint]
      STATE = STARTED
      AS TCP (LISTENER_PORT = 5023, LISTENER_IP = (10.x.x.x))
      FOR DATA_MIRRORING (ROLE = ALL, AUTHENTICATION = Windows Negotiate, 
                          ENCRYPTION = REQUIRED ALGORITHM AES)
GO

http://www.ryanjadams.com/2016/01/change-availability-group-endpoint-ip/#axzz4yzaoZP8L

https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/change-the-ip-address-of-a-failover-cluster-instance

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.