Skip to main content

Posts

Showing posts from February, 2017

SQL Server Report Server Migration - Step by Step Guide

Scenario :

Source SQL Server Reporting Instance : SQL Server 2008/12/14/16

Destination SQL Server Reporting Instance : SQL Server 2008/12/14/16

Solution : 

There are two methods for the  migration of reporting server from One instance to another. The easiest method and the hardest method. You may choose the hardest method if you want to consolidate multiple report servers into single. And if you are willing to have multiple report servers in your environment, go ahead with the easiest method.

1) Easiest method : Database Migration
2) Hardest method : Reports Migration

1) Easiest method : Database Migration
 Setps to follow : 
Backup the Source Reporting Server Databases : e.g. ReportServer and ReportServerTempDBBackup the Encryption key from Source Reporting server instance