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
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 [...]