Updating SQL Server’s Internal Server Name

Our SQL Server 7.0 server reflects the old server name instead of the current server name. All the databases on the current server, including the master database, are restored from the old server. How can I avoid passing on the old server and database names in the future? If I can't avoid this result, how can I correct it? I found a solution on the Microsoft Web site, but Step A confuses me. Here's the solution:

  • Step A—Run SQL Server 7.0 Setup from the original product installation CD-ROM. Doing this doesn't reinstall SQL Server or any components; however, it updates SQL Server 7.0 internally to reflect the new Windows computer name.
  • Step B—Start Query Analyzer, connect to the appropriate SQL Server, then run the following two stored procedures to update SQL Server's internal server name:
sp_dropserver <oldname>
sp_addserver <newname>, local

where oldname is the original computer name and newname is the new computer name.

Do I have to go through the entire installation process when I carry out Step A?

If the MSSQLServer service can't start, you need to follow Step A. However, if SQL Server is running, you can move straight to Step B.

See also, "Upgrading to SQL Server 7" and "Migrating to SQL Server 2008."

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.