• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

SQL2008 R2 - How to change current SQL clsuter IP and server name

Guys,
We plan to move this two  failover cluster to new data center, and before we plan for the move we need to ensure SQL will work when it eventually up in new data center, new data center has different rage of IP which compare to old data center and currently configure for the cluster.

Can I change the IP  for SQL lcuster ( virtual IP, server IP, server name, cluster name ) if it can, how we can do that ?
0
motioneye
Asked:
motioneye
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just change the IP's and then restart SQL Server in cluster admin (take offline / bring online).
Be careful with the applications that are connecting to databases through IP and not by instance name. And more important, if the server stays behind a firewall don't forget to update the rules.
0
 
ZberteocCommented:
Keep the server and box names the same and you should be fine. Adjust the firewall rules for IPs of the the new data center.
0
 
motioneyeAuthor Commented:
Thanks, you guys always gr8
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now