Change servername

• mngong

  SSCertifiable

  Points: 6167

  More actions

  February 10, 2004 at 7:21 am

  #84153

  SQL Server 7  Have not seen any documentation but read the following

  select @@servername produces  prod20

  but database name  and server name shows prod21

   

  To rename

  rename from Mycomputer properties

  I did check and the computer name  was the right  name prod21.....

  Reinstall software with an upgrade option(Do I need to?)

  sp_dropserver 'prod20'

  sp_addserver 'prod21' LOCAL

  Need some  confirmation to proceed

   

  Do  I need to reinstall anything or the addserver and drop server should do it

   

  Mike

   

   

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 10, 2004 at 9:32 am

  #493417

  After rename your machine name, run setup and choose upgrade option.

  The drop old name and add new name in SQL Server. Don't forget change the server name in sysjobs.

• mngong

  SSCertifiable

  Points: 6167

  More actions

  February 12, 2004 at 6:28 am

  #493787

  How do I change servername in sysjobs

   

  Mike

• mngong

  SSCertifiable

  Points: 6167

  More actions

  February 12, 2004 at 6:28 am

  #493786

  How do I change servername in sysjobs

   

  Mike

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 12, 2004 at 7:12 am

  #493795

  sp_configure 'allow updates', 1

  reconfigure with override

  use msdb

  update sysjobs set originating_server = 'new server name' where originating_server = 'old server name'

  sp_configure 'allow updates', 0

  reconfigure with override

   

• mngong

  SSCertifiable

  Points: 6167

  More actions

  May 11, 2004 at 6:01 am

  #505945

   Sorry Went to sleep on this one.Though this  looks like it could be a pretty obvious response ....

  My originating_server from sysjobs shows  local

  Does the recommended solution   above still  hold ,  or do I need to  replace  old server name  with 'local' ?

   

  Thanks  a lot

  Mike