Rename Server

• Admingod

  SSCertifiable

  Points: 5997

  More actions

  May 1, 2014 at 12:12 pm

  #306951

  I have server name called X and i want to convert this server using Virtual to virtual.However, I want to rename this server to Y.What are the steps to rename the server after V2V conversion?

• JeremyE

  SSCoach

  Points: 16199

  More actions

  May 1, 2014 at 12:36 pm

  #1710189

  You need to run sp_dropserver and sp_addserver after renaming the machine. Also, if you have SQL Agent jobs that reference the server name, you will need to update those as well.

  http://technet.microsoft.com/en-us/library/ms143799.aspx