Export (0) Print
Expand All
7 out of 16 rated this helpful - Rate this topic

Renaming a Server

SQL Server 2000

When you change the name of the computer that is running Microsoft® SQL Server™ 2000, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name.

You can connect to SQL Server using the new computer name after you have restarted the server. However, to correct the sysservers system table, you should manually run these procedures:

sp_dropserver old_name
GO
sp_addserver new_name, local
GO

When you have more than one instance of SQL Server on the computer, change the sysservers system table information by running the stored procedures this way:

sp_dropserver old_servername\instancename
GO
sp_addserver new_servername\instancename, local
GO
Issues with Remote Logins and Replication

If the computer has any remote logins, for example, if it is a replication Publisher or Distributor, sp_dropserver may generate an error similar to this:

Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44
There are still remote logins for the server 'SERVER1'.

To resolve the error, you may need to drop remote logins for this server. If replication is installed, disable replication on the server before running the sp_dropserver stored procedure.

To disable replication using the SQL Server Enterprise Manager

  1. Expand a server group, and then expand the Distributor (the server that contains the distribution database).

  2. Right-click the Replication folder, and then click Disable Publishing.

  3. Complete the steps in the Disable Publishing and Distribution Wizard.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.