A Server by Any Other Name

by
MAK [Muthusamy Anantha Kumar]

It
is imperative to change the server name when infrastructure policy changes, naming
convention standard changes or making a standby server the production server
(when production server fails). When a server name is changed, SQL server
should go through a process to acknowledge and assimilate the change in server
name. The process is a little different in different versions. I will walk you
through the process for SQL Server 6.5, 7.0 and 2000.

Change Server name:

This task is usually executed by
NT/System administrators. Soon after the Network team changes the server name,
windows will prompt you to restart the server.

Restart the server.