HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Changing IP Addresses of an Always On Availability Group in SQL Server 2014

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
groupsqlalwaysaddressesavailabilityserverchanging2014

Problem

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?

Solution

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

Code Snippets

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

Context

StackExchange Database Administrators Q#174359, answer score: 4

Revisions (0)

No revisions yet.