February 14, 2015 at 4:30 am
Hi everyone,
I have two sql instances installed in two node failover cluster mode, i want to rename one of my sql instance, is it possible to change instance name ,
if possible please suggest the way how i can rename the instance name.
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
February 14, 2015 at 8:16 am
Quick answer, NCD (no can do), suggest uninstalling installing and attach the DBs
😎
February 16, 2015 at 2:57 am
aprathour.89 (2/14/2015)
Hi everyone,I have two sql instances installed in two node failover cluster mode, i want to rename one of my sql instance, is it possible to change instance name ,
if possible please suggest the way how i can rename the instance name.
The only object you change here is the virtual networkname, it sounds like you have a clustered default instance you wish to change to a named instance. To do this you must uninstall the default and reinstall a named instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply