Renaming a SQL server

[Steve Bajada]

We have a need to rename one of our SQL servers. Has anyone had any
experience doing so? If so, what needs to be done?

Thanks,

Steve Bajada
WWW.Audiobasket.com

[BPMargolin]

Steve,

The first place to look for answers (after the SQL Server Books Online) is SQL
Server MVP Neil Pike's FAQ ... the following is from it ... to see all of the
entries in Neil's FAQ, find any post from Neil (there are hundreds to choose
from), and follow the hyper links in his signature.

Q. How do I change the name of SQL Server?

A. If you change the NT name of a server and want to change SQL Server 6.5 or
below to match it then do :-

sp_dropserver <oldname>
go
sp_addserver <newname>, local

In addition, if you use the IPX/SPX netlib for SQL Server connectivity you must
also run the SQL Setup, choose the option to change the network support, and fix
the server name in there too.

With SQL 7.0 you will need to re-run setup to reset the server name. Setup will
detect the name conflict, resolve it, and then finish.

===

v1.03 1999.11.02
Applies to SQL Server versions : All
FAQ Categories : Server Administration and Tools
Related FAQ articles : n/a
Related Microsoft Kb articles : n/a
Other related information : n/a
Authors : Neil Pike

---------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.

Steve Bajada <sba...@sonic.net> wrote in message
news:395D142A...@sonic.net...