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?

  • 1
    This , this and this will help. – SqlWorldWide May 23 '17 at 18:07
  • Sorry my 3rd link is not relevant and I cannot edit a comment after certain time. You rather consult this link. – SqlWorldWide May 24 '17 at 2:12
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://docs.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, privacy policy and cookie policy

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