Answered by:
SSRS Migration SECURITY question

Question
-
Hi There, My goal is to migrate all my reports from one server to a new server and SQL on current prod is 2014 and new server will have 2016. My SSRS is of native mode on both servers. I am doing this in parallel, so rollback would be easy jic. I have read articles to backup and restore ReportServer and ReportserverTempdb databases followed by encryption key. My question here is does this take care of all components related to reporting services? Can anyone respond on security? Does this include all reports, users, roles if any. Please let me know anything I have to backup and move to new server apart from backup and restore process.
Sincerely
RRR
Monday, March 18, 2019 6:06 PM
Answers
-
According to your description , seems that you want to know , if it is fine to just copy and restore the report server database ,Reportserver tempdb database and the encryption key.
As far as I know, besides the database and the encryption key you could also try to mind the following aspects.
- You should also try to copy the configure file to the new ssrs instance . see: Backup Files and Data
- For the custom assembly for the report and the custom extension , you could also try to copy to the new instance and check it works fine or not . see: Move Custom Assemblies or Extensions
- If you want to migrate the report subscription to the new instance ,seems you could try to migrate the subscription via the rs.exe tools or you need to export the corresponding jobs (mapping to the subscription ) out and import to the new ssrs instance .
See: SSRS Subscription migration
Other things include the report role ,user security are all stored in the report server database. you could do the migration followed by the official document .
Hope it can help you.
Best Regards,
Eric Liu
Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if 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.
- Edited by Mitarai Queen Tuesday, March 19, 2019 2:10 AM
- Proposed as answer by Mitarai Queen Wednesday, March 20, 2019 9:33 AM
- Marked as answer by Ravi Kandukuri Thursday, March 21, 2019 6:35 PM
Tuesday, March 19, 2019 2:05 AM
All replies
-
According to your description , seems that you want to know , if it is fine to just copy and restore the report server database ,Reportserver tempdb database and the encryption key.
As far as I know, besides the database and the encryption key you could also try to mind the following aspects.
- You should also try to copy the configure file to the new ssrs instance . see: Backup Files and Data
- For the custom assembly for the report and the custom extension , you could also try to copy to the new instance and check it works fine or not . see: Move Custom Assemblies or Extensions
- If you want to migrate the report subscription to the new instance ,seems you could try to migrate the subscription via the rs.exe tools or you need to export the corresponding jobs (mapping to the subscription ) out and import to the new ssrs instance .
See: SSRS Subscription migration
Other things include the report role ,user security are all stored in the report server database. you could do the migration followed by the official document .
Hope it can help you.
Best Regards,
Eric Liu
Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if 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.
- Edited by Mitarai Queen Tuesday, March 19, 2019 2:10 AM
- Proposed as answer by Mitarai Queen Wednesday, March 20, 2019 9:33 AM
- Marked as answer by Ravi Kandukuri Thursday, March 21, 2019 6:35 PM
Tuesday, March 19, 2019 2:05 AM -
Thanks Eric, I was able to backup and restore the Reportserver backup followed by key. It all went fine. you couple extra steps are definitely the best to consider.
thanks for the response
Thursday, March 21, 2019 6:32 PM