Answered by:
Migrating SSRS 2014 to 2019

Question
-
'm currently migrating a 2014 SQL Server to 2019. Currently, we have a 2014 server name MY_SQL_SERVER and 2019 with server name MY_SQL_SERVER_NEW. Eventually, this 2019 server will be renamed MY_SQL_SERVER and the 2014 will be decommissioned.
I restored the 2 reporting DBs into the new server and configured SSRS. It is up and running.
Some questions:
- Best way to handle renaming the SQL Instance for SSRS?
- How to migrate subscriptions?
- Anything I may have missed.
- Do I just delete the old one below?
TIA
- Edited by ARPRINCE Friday, June 12, 2020 2:01 PM
Friday, June 12, 2020 2:00 PM
Answers
-
Hello TIA,
Thanks for posting questions here.
If I understand correctly, you have migrated SSRS 2014 to SSRS 2019 now, and the SSRS 2019 server is MY_SQL_SERVER_NEW, you want to rename it to MY_SQL_SERVER, right? I think you two may phase you should do:
1. Migrate SSRS 2014 to SSRS 2019
You can follow this article: Migrating SQL Server Reporting Services
2. Rename SSRS 2019 server name to MY_SQL_SERVER
You can follow to this article: Rename a Report Server Computer
For your questions, below is some suggestion:
- Best way to handle renaming the SQL Instance for SSRS?
SQL Server instance name cannot rename after creating. However you can change the server name. Then you can change the server name for SSRS in Reporting Service configuration Tool or please follow the linkage I post in phase 2.
- How to migrate subscriptions?
In Reporting Services, subscriptions are reserved in report server databases. When we move report server database to a new server, the schedules will be recreated the first time that you restart the Report Server service, and SQL Server Agent jobs that are used to trigger a schedule will be recreated on the new database instance. For more information, please refer to this article: Moving the Report Server Databases to Another Computer (SSRS Native Mode)
- Anything I may have missed.
I think above linkages is enough. In case of any failure, please do test in development environment firstly before implement this in produce environment.
- Do I just delete the old one below?
This is scale-out deployment. Please refer to Scale-out Deployment (Native Mode Report Server) .If you will not using the old one in future, it will be ok for deleting it.
Hope it will help
Best Regards
Dawn
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.- Edited by Dawn YoungMicrosoft contingent staff Monday, June 15, 2020 3:27 AM
- Proposed as answer by Dawn YoungMicrosoft contingent staff Tuesday, June 16, 2020 1:54 AM
- Marked as answer by ARPRINCE Thursday, June 18, 2020 2:49 PM
Monday, June 15, 2020 3:26 AM
All replies
-
Hello TIA,
Thanks for posting questions here.
If I understand correctly, you have migrated SSRS 2014 to SSRS 2019 now, and the SSRS 2019 server is MY_SQL_SERVER_NEW, you want to rename it to MY_SQL_SERVER, right? I think you two may phase you should do:
1. Migrate SSRS 2014 to SSRS 2019
You can follow this article: Migrating SQL Server Reporting Services
2. Rename SSRS 2019 server name to MY_SQL_SERVER
You can follow to this article: Rename a Report Server Computer
For your questions, below is some suggestion:
- Best way to handle renaming the SQL Instance for SSRS?
SQL Server instance name cannot rename after creating. However you can change the server name. Then you can change the server name for SSRS in Reporting Service configuration Tool or please follow the linkage I post in phase 2.
- How to migrate subscriptions?
In Reporting Services, subscriptions are reserved in report server databases. When we move report server database to a new server, the schedules will be recreated the first time that you restart the Report Server service, and SQL Server Agent jobs that are used to trigger a schedule will be recreated on the new database instance. For more information, please refer to this article: Moving the Report Server Databases to Another Computer (SSRS Native Mode)
- Anything I may have missed.
I think above linkages is enough. In case of any failure, please do test in development environment firstly before implement this in produce environment.
- Do I just delete the old one below?
This is scale-out deployment. Please refer to Scale-out Deployment (Native Mode Report Server) .If you will not using the old one in future, it will be ok for deleting it.
Hope it will help
Best Regards
Dawn
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.- Edited by Dawn YoungMicrosoft contingent staff Monday, June 15, 2020 3:27 AM
- Proposed as answer by Dawn YoungMicrosoft contingent staff Tuesday, June 16, 2020 1:54 AM
- Marked as answer by ARPRINCE Thursday, June 18, 2020 2:49 PM
Monday, June 15, 2020 3:26 AM -
Thanks for the links. Helped me with subscriptions as well.
I used below to rename my SQL Server with default instance.
https://www.sqlservercentral.com/blogs/rename-or-change-sql-server-standalone-default-instanceThursday, June 18, 2020 2:50 PM