Link to home
Start Free TrialLog in
Avatar of Eprs_Admin
Eprs_AdminFlag for Austria

asked on

IP change of AG

Hi Experts,

I have running 2 SQL2014 Servers in a AG.
The WIN OS is WIN2012R2.

I have to change IPs of all servers because of a move into a new DC.

Can you help me with the steps ?
What to do first ?
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Are the SQL Server instances stand-alones or clustered?
If they are  clustered instances then stop SQL Server service and change the SQL IP Address (all this tasks need to be performed in the Failover Cluster Manager snap-in). The start the SQL Server with the new IP address.
If they are stand-alones, stop the SQL Server service and change the IP locally before start again the SQL Server service.

For AG, you'll need to drop the listener from the Principal replica and recreate it giving the new IP address.
Avatar of Eprs_Admin

ASKER

I have two servers. I have a windows cluster. the DBs are clustered with the AG.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So you have 2 stand-alone SQL Server instances, right?
YES.

It should be DBs are replicated through AG?
YES