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.

The Network for Technology Professionals


About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers