Sometimes its a necessity to rename a SQL server or SQL server instance. I had to rename it couple of times in my IT career.
These are steps that I made.
exec sp_dropserver ‘oldserver’
exec sp_addserver ‘newserver’,’local’
restart the sql server and check whether below query output is same or not .
step3 : for updating jobs – if you have any
set originating_server = serverproperty(‘servername’)
Once I used this procedure to rename newly installed SQL server, the second time it was on “production” server.
On the production server, I had to reinstall Reporting Server, because there was no way I could get it going of all the relations to old server name.
But database server, and jobs and connection to renamed server worked.
So, to everybody, good luck!