Thursday, November 14, 2013

Migrating Reporting Services To Another Server

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.

No comments: