Rename sql server 2012 cluster instances on active active cluster
Posted on 2014-09-25
I have set up a active/active cluster with two nodes
Windows cluster name
sql group 1
sql group 2
Sql Virtual instance names
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.