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.

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles