Renaming Clustered SQL 2005 server and changing IP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 21 Jul 2008 16:51 GMT

Has anyone ever renamed a clustered SQL 2005 Server and also change the IP
address of the instance? Do I just change the parameters in the respective
cluster resources to reflect the new name and Ip address? Do I need to run
the sp_dropserver/sp_addserver command?

Thanks!

Reply to this Message

Denny Cherry - 21 Jul 2008 21:52 GMT

You will need to do the sp_dropserver/sp_addserver as normal.

You will also need to search the registry for the IP that the SQL
Server used to listen on and change it there as well as changing it
within the Cluster Admin.

Denny

>Has anyone ever renamed a clustered SQL 2005 Server and also change the IP
>address of the instance? Do I just change the parameters in the respective
>cluster resources to reflect the new name and Ip address? Do I need to run
>the sp_dropserver/sp_addserver command?
>
>Thanks!

Reply to this Message