A Server by Any Other Name

April 24, 2003

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.