Bev,

I have the following documented when we renamed our NT server, which already
had SQL Server 2000 installed. Reading this back, I note a few items with
2000 only, but I cannot remember why I indicated that.

Maybe someone can tell us wether You will be able to use the steps below to
rename your server.

Thanks.

Sang Nahm

****************************************************************************
********************************
How to handle SQL Server name change after SQL server installation or to set
up a new server based on the existing servers:

* Before renaming the server, script out all of the jobs and then delete
them. Rename the server to the new name-SQL Server 2000 and above only. If
you do not want to rename the server back to its original name, you can
modify msdb..sysjobs table and modify the table then delete the existing
jobs from the old server name. But using this method, you will have to
recreate the scripts.
* Sp_dropserver <old_name>
* Sp_addserver <new_name>, 'local'
* Restart the SQL Server Sservice for the change to @@SERVERNAME to take
effect.
* Copy local packages if needed. Be sure to check on connections to ensure
that it is pointing to the new server.
* Add back the jobs by running the script generated from the first step-SQL
Server 2000 and above only.

Note: SQL Server 7.0 stores in the msdb..sysjobs table, the file
originating_server value to '(local)' referencing the local server.
Therefore, no matter how the server name is modified, the change does not
affect the local server jobs. SQL Server 2000 on the other hand supports
multi-instances, the originating_server field contains the instance name in
the format 'server\instance'. Even for the default instance of the server,
the actual servername is used instead of '(local)'. Therefore, after the
Windows server is renamed, these jobs still reference the original server
name and may not be updated or deleted by the process from the new server
name.
****************************************************************************
**********************************
-----Original Message-----
From: Hyra, Bev A [mailto:[Email Address Removed] Friday, June 28, 2002 12:45 PM
To: '[Email Address Removed] Changing the name of your server running sql server 7


Hi everyone,

If you have an installation of sql server 7 running on a server and you want
to change your servers name, how does this affect the installation of sql
server 7 that you have running? Can you keep it running?

Thanks in advance for all replies.

Bev.


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page