SQL: changing your database server name

29 Dec 2010

When you change the name of your server which is running SQL, you should also make sure that SQL gets updated with this new name. Proceed with the following procedure:

  • execute the command: select @@servername
    this command will return the current servername stored in SQL
  • execute the command: sp_dropserver ‘servername‘
    in which servername is the name that you got from the previous step
  • execute the command: sp_addserver ‘new servername’
  • restart the “ sql server”  service and the “ sql server agent” service
  • execute the command: select @@servername
    to verify everything went just fine :-)

1 Response to SQL: changing your database server name

Avatar

SQL: maintenance plan delete after server rename - Marc Valk dot Net

April 12th, 2011 at 09:20

[...] a previous post I spoke about changing your database server name. If you created a maintenance plan, you might [...]

Comment Form