Solved

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

Posted on 2015-01-18
3
104 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 47

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

786 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