Server Name Change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 30 Nov 2007 02:42 GMT

I want to install SQL 2000 on a new Win 2003 server which has a temporary
name of Tmp01. When we are ready to replace the old Win 2000 server named
SQL01 with the new Tmp01, I will rename Tmp01 to SQL01 and take the original
SQL01 offline.

Am I going to run into issues changing the server name from Tmp01 to SQL01
after SQL Server has been installed and configured?

Reply to this Message

bass_player [SBS-MVP] - 30 Nov 2007 03:35 GMT

When you change your server hostname, it is still registered in your SQL
Server instance. Run sp_helpserver for more details. Run the sp_dropserver
system stored procedure, passing the instance name of your olde SQL Server
instance. After changing the new Windows Server 2003 hostname to SQL01, run
sp_addserver and pass your new instance name

>I want to install SQL 2000 on a new Win 2003 server which has a temporary
> name of Tmp01. When we are ready to replace the old Win 2000 server named
[quoted text clipped - 4 lines]
> Am I going to run into issues changing the server name from Tmp01 to SQL01
> after SQL Server has been installed and configured?

Reply to this Message

Tibor Karaszi - 30 Nov 2007 12:28 GMT

http://www.karaszi.com/SQLServer/info_change_server_name.asp

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

>I want to install SQL 2000 on a new Win 2003 server which has a temporary
> name of Tmp01. When we are ready to replace the old Win 2000 server named
[quoted text clipped - 3 lines]
> Am I going to run into issues changing the server name from Tmp01 to SQL01
> after SQL Server has been installed and configured?

Reply to this Message