Rename SQL SERVER NAME

• shree

  Say Hey Kid

  Points: 702

  More actions

  November 16, 2009 at 5:06 pm

  #213901

  Folks

  i have changed the sql server name successfully but when i do sp_helpservers it returns the changed name means new name but when i do @@servername it returns the old name not sure where i can change it

  or what i am missing.

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  November 16, 2009 at 5:45 pm

  #1079981

  @@servername is cached data, recycling the SQL service will resolve this issue.

  SERVERPRORTY('servername') should tell you the current renamed server name.

  Thanks

  Jay.

  Thanks
  Jay
  http://www.sqldbops.com

• lokhande.deepali

  SSC Eights!

  Points: 833

  More actions

  November 17, 2009 at 12:36 am

  #1080067

  We can change the server name for only default instance by changing the hostname. But in case of named instance we can not change the Server name.

  If any one know how to change name of named instance..

  Suggest.

  Rd,

  Deepali

• john.campbell-1020429

  Ten Centuries

  Points: 1194

  More actions

  November 18, 2009 at 7:13 am

  #1080879

  Check this link. http://msdn.microsoft.com/en-us/library/aa197071%28SQL.80%29.aspx

  Seems to cover the ground. I have only renamed the default instance with a reboot to make the change.

  Good luck,

  John.