Server IP change

Question

Server IP change

sqlguru

SSC-Addicted

Points: 471
More actions
January 17, 2023 at 6:35 pm

#4138714

We are planning to change the server IP of normal SQL Server instance, not a cluster. My understanding is this change should be a transparent change. Restarting the sql server is what needs to be done after the IP change. Let me know if I am missing anything?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Nope, this should be it. Clients that connect by IP will have issues, but the server will start listening on the new IPs when it starts.

Might check that the configuration manager isn't specifically set up to point to an IP as opposed to any IPv4 or any IPv6.

sqlguru SSC-Addicted Points: 471 More actions · Answer 2

Thanks Steve. Do the network team has to open up firewalls to listen the TCP port to the new IP address?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

They may. That is basic networking stuff. Clients need to be able to send a packet on whatever port you have the server listening on, plus the browser if you use that service.

sqlguru SSC-Addicted Points: 471 More actions · Answer 4

Other than looking in DNS, is there any other ways to make sure nothing was pointing to the IP for the SQL side of things?

This reply was modified 1 year, 10 months ago by sqlguru.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

You can track the sessions and look for IPs, but you can't be sure of where clients connect from, given proxies and firewalls. Not always easy to ensure what is connecting.

sqlguru SSC-Addicted Points: 471 More actions · Answer 6

On a different note, we are doing firmware upgrade on Always on AG group but this upgrade is pushed all at once to both UAT and Prod. I was hoping to suspend the data movement until the upgrade is done. Do you think of anything this should be done differently or cause any issues or better approach?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Best to start a separate thread for this, so people can find the answer.