A Server by Any Other Name
April 24, 2003by 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.