I have a cloned (duplicate) server with SQL Server on it and the server name had to obviously change once it was copied. This article describes two actions to perform:
using below code to manually rename SQL Server:
sp_dropserver <old_name>; GO sp_addserver <new_name>, local; GO
some changes in SSRS.
My questions are:
are there other things I need to consider/change?
Despite following all of those items, I still get the following issue: in SSRS Configuration Manager, under Scale-out Deployment, I still have a reference to the old server.
Isn't that article incomplete given it does not speak of SSAS, SSIS, and Linked servers?
- SQL Server in question has just one instance (default)
- There exists no mirroring, failover cluster, replication, etc. It's a simple case.