Renaming the default clustered instance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasquale - 22 Jul 2008 09:02 GMT

Is it possible to rename the default SQL Server 2005 instance installed in a
cluster? I would like to rename the instance name and not the virtual server
name.
Thanks

Reply to this Message

Uri Dimant - 22 Jul 2008 13:12 GMT

Hi
You will have to uninstall and re-install the instance

> Is it possible to rename the default SQL Server 2005 instance installed in
> a
> cluster? I would like to rename the instance name and not the virtual
> server
> name.
> Thanks

Reply to this Message

Geoff N. Hiten - 23 Jul 2008 02:50 GMT

You cannot rename an instance. You can use a DNS alias to create a second
name. You can install a second instance, detach the database from the first
one, fix the cluster resource groups and object dependencies, and attach the
databases to the new instance.

Signature

Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

> Is it possible to rename the default SQL Server 2005 instance installed in
> a
> cluster? I would like to rename the instance name and not the virtual
> server
> name.
> Thanks

Reply to this Message

Linchi Shea - 23 Jul 2008 04:08 GMT

I personally like the network alias approach because in that case you move
the databases to a new server and the apps don't have to change anything.

Linchi

> Is it possible to rename the default SQL Server 2005 instance installed in a
> cluster? I would like to rename the instance name and not the virtual server
> name.
> Thanks

Reply to this Message