troubleshooting Question

Impact to an SQL 2012 server if IP address needs to be changed

Avatar of sunhux
sunhux asked on
Microsoft Legacy OSMicrosoft DevelopmentMicrosoft SQL Server 2008
2 Comments2 Solutions2023 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
rk_india1

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros