Changing the server name and IP address

[steven virnig]

A server with SQL 2000 installed is moving to a new physical location. Our
company standards mean that the name of the server and the IP address of the
server will change also. This SQL instance name is the same as the server
name. Will I have to uninstall and reinstall SQL Server (and recover the
databases) when this move is made so that the instance name equals the
server name? Is there a stored procedure that changes the instance name to
the server name? Thank you.

[Erland Sommarskog]

[posted and mailed, please reply in news]

steven virnig (pe****@mn.rr.com) writes:

A server with SQL 2000 installed is moving to a new physical location.
Our company standards mean that the name of the server and the IP
address of the server will change also. This SQL instance name is the
same as the server name. Will I have to uninstall and reinstall SQL
Server (and recover the databases) when this move is made so that the
instance name equals the server name? Is there a stored procedure that
changes the instance name to the server name? Thank you.

If memory serves, it's as simple as:

exec sp_dropserver @@servername
exec sp_addserver 'NewName', 'local'
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp