A Server by Any Other Name - Page 2

Process involved in SQL Server 6.5

Step 1 Change client configuration

Open the Client configuration utility and remove the existing connection property.

Select the old server name and click 'remove'

Add the changed server name in the client configuration utility.

Step 2 Register server name

Open Enterprise Manager and remove the existing registration with the old server name. Register the new server name.

Step 3 Update sysservers

Open ISQL/W and run the following statement; it will still display the old server name.

select @@servername

Run the following sql commands.

Use master
go
sp_dropserver 'oldservername'
go
sp_addserver 'changeserver'
go

Step 4: update clients and other servers

Update all of the clients (Follow step1) to point to the new server and any linked server you have updated with the new name. Make sure any user DLLs and web servers pointing to the server name point to the new server name.