Home Forums SQL Server 2008 SQL Server 2008 - General Rename Server RE: Rename Server
JeremyE
SSCoach
Points: 16121
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