Impact to an SQL 2012 server if IP address needs to be changed
Posted on 2013-12-07
I have a VM running guest OS Win2012 (Datacentre) that's installed
with SQL2012 with a database (not clustered, just one node as it's
a Staging server).
We plan to migrate this VM to another VLAN (for some mandatory
corporate reason) thus this VM will have to assume a different IP
address. What's the impact of changing the IP address?
Will SQL2012 & its instance still run after the IP change & any other
changes/updates needed when the IP address is changed?
Certainly I'll need to update the DNS entry with the new IP but
I guess as long as the apps are referring to it using hostname
or FQDN, then no changes needed to the apps, right?