patternsqlMinor
Changing IP Addresses of an Always On Availability Group in SQL Server 2014
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?
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
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
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)
GOhttp://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)
GOContext
StackExchange Database Administrators Q#174359, answer score: 4
Revisions (0)
No revisions yet.