Renaming a SQL 2000 Cluster

I need to migrate our SQL 2000 cluster to a new set of hardware and name
the new cluster with the same name as the existing one so that none of the
applications are affected. How do I change name of a SQL Cluster ?
Amila
Unfortunately, the only way to "Change" the virtual network name is to
uninstall and reinstall.
There are really only two choices: in-place system upgrade (rolling upgrade)
or a new cluster installation while aliasing the old SQL Server host name.
Read through the clustering news group as this question comes up quite
frequently.
Sincerely,
Anthony Thomas

"Amila chandrasekera" <achandra@.insight.com> wrote in message
news:O4HMyfDVHHA.4832@.TK2MSFTNGP04.phx.gbl...
> I need to migrate our SQL 2000 cluster to a new set of hardware and name
> the new cluster with the same name as the existing one so that none of the
> applications are affected. How do I change name of a SQL Cluster ?
>
> Amila
>
|||You can also have the older Cluster Virtual Name redirect to the newer name.
This would require NT Admin help but you dont need to do anything at the SQL
end as long as you are sure that you dont need the older cluster anymore and
can get rid of it.
"Anthony Thomas" wrote:

> Unfortunately, the only way to "Change" the virtual network name is to
> uninstall and reinstall.
> There are really only two choices: in-place system upgrade (rolling upgrade)
> or a new cluster installation while aliasing the old SQL Server host name.
> Read through the clustering news group as this question comes up quite
> frequently.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Amila chandrasekera" <achandra@.insight.com> wrote in message
> news:O4HMyfDVHHA.4832@.TK2MSFTNGP04.phx.gbl...
>
>
sql

Rename A Server

We want to migrate a SQL 7 to SQL2000 (there will be a new box) and then rename the old SQL 7 box and keep it on the network.
Seems like I remember there is a problem when your rename a SQL server.
Anyone have experience with this?
Thanks
ChuckCheck this out (http://www.databasejournal.com/scripts/article.php/1496451)|||...And this is what M$ says about this process:

Q. Can I rename a server after installing SQL Server 2000?

A: Yes, you can rename a server after the installation of SQL Server 2000. When the SQL Server service starts for the first time after the name change, it automatically recognizes the change and resets the computer name. You do not need to run setup again to reset this value. However, you must perform several additional configuration steps. To correct the sysservers system table, you should manually run the following procedures.

For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go

For a named instance:sp_dropserver <old_servername\instancename>
go
sp_addserver <new_servername\instancename> , local
go|||Thanks.

I'll try that. It is actually SQL 7. We are upgrading a SQL 7 server to SQL 2000. The SQL 2000 is a new box and we want to keep the SQL 7 server around on the lan for a while.

Thanks again

Chuck