SSRS : How to migrate Reports from Source Server to Target Server

The Problem!

---

You need to migrate a SQL Server Reporting Services (SSRS) Native Mode environment installed on one server and move it all to another server. Check out this tip to learn the steps

The Solution 

---

The Overview steps;

 

1. Backup SSRS databases on the source server 
2. Backup Encryption Key on the source server 
3. Restore SSRS databases on the target server 
4. Restore the Encryption Key on the target server 
5. Remove the old server name from the Keys table on the target server (Option) 
6. Test the reports

 Source Server 

---

1- Backup the Report Databases by SSMS SQL server Managment Studio

Recommanded!

---

if you dont know SSMS or you dont know how to use it or download it, Please see this Video , it will support you Clik to watch video

2- Backup the encryption key by opening the Reporting Services Configuration Manager on the source server Encryption Keys

 

1. Backup Enter the directory and file name Give it a password that meets your domain requirement
2. Confirm the password
3. Click OK

Recommanded!

---

if you would like to know how to install SSRS and configure it , i recommand to see this Video Clik to watch video

Target Server

---

Open the  Reporting Services Configuration Manager  on the new server. 

1. Copy the backup files (Database backup and Encryption Key) from the source to the target server 
2. Restore the report Database to target SQL Server by SSMS 
3. Change the Database configration to target database after restore step#1 and select the new database as below important steps

4. delete All the Existing Keys if the OLD NOT NEED any more as below

5. Restore the Encryption Key by Reporting Services Configuration Manager as below steps

6.test the Report Portal by Open the portal url

Checklist

---

Also, here's a handy checklist to use if you like simple checklists like I do.

SSRS Migration Checklist

• Source Server
  • Backup ReportServer and ReportServerTempDB together
  • Copy backups to the target server
  • Backup SSRS Encryption Key
• Target Server
  • Stop Reporting Services thru Reporting Services Configuration Manager (Option till restoring the databases activity)
  • Restore ReportServer and ReportServerTempDB from backups
  • Fix logins and users
  • Start Reporting Services
  • Verify no login errors
  • Restore Encryption Key
  • Validate at http://TargetServerName/Reports/
  • Test Portal 
  • Work to update the datasources for reports data