Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Rename sql server 2012 cluster instances on active active cluster

Posted on 2014-09-25
2
Medium Priority
?
363 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 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

715 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