MAK [Muthusamy Anantha Kumar]
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
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.
Run the following sql commands.
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