Renaming a SQL2K server

• Richard Rice

  SSC Eights!

  Points: 879

  More actions

  April 16, 2004 at 11:31 am

  #82558

  Is it possible to rename an instance of SQL Server? I'm thinking we can't, but want to check.

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  April 16, 2004 at 12:58 pm

  #503191

  From BOL...

   

  sp_dropserver old_servername\instancename

  GO

  sp_addserver new_servername\instancename, local

  GO

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 16, 2004 at 1:44 pm

  #503206

  With the above help you can. But if you have setted up replication, then I would suggest to reinstall SQL, because it can get bad configured.