Renaming SQL 2005 Virtual Server and assigning new IP   

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!

date: Mon, 21 Jul 2008 09:48:47 -0400   author:   Steven

RE: Renaming SQL 2005 Virtual Server and assigning new IP   

You can follow the steps documented in BOL to change the virtual server name:

http://msdn.microsoft.com/en-us/library/ms178083.aspx

Linchi

"Steven" wrote:

> 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! 
> 
> 
>

date: Mon, 21 Jul 2008 11:08:12 -0700   author:   Linchi Shea

RE: Renaming SQL 2005 Virtual Server and assigning new IP   

And the steps for changing IP addresses are documented in this KB article:
http://support.microsoft.com/kb/244980

Linchi

"Steven" wrote:

> 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! 
> 
> 
>

date: Mon, 21 Jul 2008 11:09:01 -0700   author:   Linchi Shea