Renaming machinename and servername in Server Properties

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  December 1, 2014 at 11:00 am

  #292979

  hi all, This is for 2012

  By running sp_drop server and sp_addserver, I was able to change @@SERVERNAME

  But SELECT serverproperty('ServerName') and Select ServerProperty('machinename')

  still return the old name.

  Is there any way to rename ServerName and machineName, without having to reinstall SQL Server?

  (I'm trying to get these values to match the actual Windows server name)

  Thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 1, 2014 at 11:44 am

  #1761825

  Did you restart SQL Server? According to this BOL Article the new name is recognized at SQL server startup.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  December 1, 2014 at 12:01 pm

  #1761835

  Thanks Jack.

  Yes, I actually rebooted this server before I checked the value of machinename, servername.

  select @@servername does return the correct name.

  but SELECT serverproperty('ServerName') still reflects the old name.