Solved

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

Posted on 2015-01-18
3
103 Views
Last Modified: 2015-01-21
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
Comment
Question by:motioneye
3 Comments
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 300 total points
ID: 40557345
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
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 200 total points
ID: 40557693
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
 

Author Closing Comment

by:motioneye
ID: 40561536
Thanks, you guys always gr8
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now