March 28, 2012 at 11:26 am
Does anyone know if it is possible to change the names of your SQL Server and the instance name in a cluster area. example would be sql05\isql05 and then change it to sql11\isql11. Thank you for all your help.
Kind Regards,
Abdul
March 28, 2012 at 12:53 pm
Abdul Walele (3/28/2012)
Does anyone know if it is possible to change the names of your SQL Server and the instance name in a cluster area. example would be sql05\isql05 and then change it to sql11\isql11. Thank you for all your help.Kind Regards,
Abdul
From How to: Rename a SQL Server Failover Cluster Instance:
Although you can change the name of the virtual server, you cannot change the instance name. For example, you can change a virtual server named VS1\instance1 to some other name, such as SQL35\instance1, but the instance portion of the name, instance1, will remain unchanged.
As far as I know you cannot rename a named instance...but maybe this has changed in SQL 2012, I haven't tried it. For now it appears you can at least go from sql05\isql05 to sql11\isql05, but you are stuck with the instance name isql05.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 2:36 pm
to change the instance name you would have to install a new 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