Solved

Rename sql server 2012 cluster instances on active active cluster

Posted on 2014-09-25
2
338 Views
Last Modified: 2014-10-09
Hello All,

I have set up a active/active cluster with two nodes

Physical Nodes:
MATLKBIR1CLP001
MATLKBIR1CLP002

Windows cluster name
MATLKBIR1VLP001

sql groups
sql group 1
sql group 2

Sql Virtual instance names
First instance:MATLKBIR1SQP001
Second Instance:MATLKBIR1SQP002

The cluster is up and running however I need to change the sql instance names
MATLKBIR1SQP001 to MATLKBIR1SQP003
MATLKBIR1SQP002 to MATLKBIR1SQP004

I have following questions to be answered
1.Can we change the instance names without effecting entire windows and sql clusters?
2.if yes, what is the process should be followed
3.if there is any issue, how do we roll back
4.Any Ramifications/issues of after  doing the instance name changes during failover/failback process.
0
Comment
Question by:chandradineshbabu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40345607
Those instances have databases? If not I will recommend you to uninstall them and install new instances.
If you want to go forward with this, here's the MSDN article on how to do it.
0
 

Author Closing Comment

by:chandradineshbabu
ID: 40372284
Thanks for the solution
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

622 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