Change server name 1

[clapag22]

We have a server named LSSQL02. It's getting old and out-dated so we ordered a new server. The new server has come in and the Network Admin installed Windows 2K and all that fun stuff. He named the server LSSQL04. I installed SQL2K and Analysis Server. Now the powers that be want me to move all the DB's from LSSQL02 to LSSQL04, take the current LSSQL02 off-line and rename LSSQL04 to LSSQL02. I guess my question is... What do I need to from a SQL perspective to do this if anything? The Network Admin will obviously physically rename the server, but what do I need to do in SQL? I imagine the server name exists somewhere in the Master DB...

Thanks!
CML

 

[vadimg]

Here's how to rename a server running SQL Server:

1. Rename the physical server by going to the "Network Identification" tab of the "Computer" Properties windows (available from Control Panel).
2. Reboot the server.

3. Run the SQL Server setup program. At some point early in the installation you will be prompted to "Upgrade" SQL Server. Answer "yes" to this question. After a very short period of time, you will be prompted that the installation is complete.

4.Reboot the server.

5. run &quot;sp_dropserver <old server name>&quot;
6. run &quot;sp_addserver <new server name>, local&quot;

Once you have completed all these steps, SQL Server will now recognize its new name. But keep in mind that this procedure is only for SQL Server. It will not affect how other software running on the server will be affected by the name change. If you have clients who are pointing to your server (including DSNs), they will also have to be changed to point to the new SQL Server name.

 

[clapag22]

Thank you!