At the time of hardware upgrade or version upgrade we may need to move SSRS databases to new server, Below are the steps which helps to move SSRS databses
For example we are moving reporting services from Server A to Server B
1. Backup ReportServer, ReportServerTempDB Database in Source from Server A database (ReportServerTempDB is not mandatory)
2. Backup SSRS Encryption Key from Reporting Services Configuration manager from Server A
3. Copy SSRS database backups and encryption key to Server B manually.
4. Stop Reporting Services in Server B
5. Restore ReportServer and ReportServerTempDB databases on Server B
6. Configure ReportServer using Reporting Services Configuration window and while selecting databases select use existing option and select ReportServer database from Server B
7. Restore Encryption key on Server B
8. Restart Reporting Services
9. From SSMS, Query the keys table in ReportServer Database
You will able to see two different keys in that tables, One key belongs to current machine and another key belongs to Server A (because we restored database from Server A)
10. Delete that ServerA entry from the keys table
11. Remove the Server A entry from the Scale-out deployment tab Reporting Services Configuration wizard
12. Restart Reporting Services
Now you can able to access the report without any issues.
For example we are moving reporting services from Server A to Server B
1. Backup ReportServer, ReportServerTempDB Database in Source from Server A database (ReportServerTempDB is not mandatory)
2. Backup SSRS Encryption Key from Reporting Services Configuration manager from Server A
3. Copy SSRS database backups and encryption key to Server B manually.
4. Stop Reporting Services in Server B
5. Restore ReportServer and ReportServerTempDB databases on Server B
6. Configure ReportServer using Reporting Services Configuration window and while selecting databases select use existing option and select ReportServer database from Server B
7. Restore Encryption key on Server B
8. Restart Reporting Services
9. From SSMS, Query the keys table in ReportServer Database
You will able to see two different keys in that tables, One key belongs to current machine and another key belongs to Server A (because we restored database from Server A)
10. Delete that ServerA entry from the keys table
11. Remove the Server A entry from the Scale-out deployment tab Reporting Services Configuration wizard
12. Restart Reporting Services
Now you can able to access the report without any issues.
No comments: