Migrate SQL Server Reporting Services database from SSRS 2012 to SSRS 2016

10 May,2018 by Jack Vamvas

Question: I need to migrate and upgrade an SSRS 2012 database to an SSRS 2016 .

Could you supply me with a general framework for a migration path .

Answer:This is a basic framework and you may need to build in extra some extra steps to prepare and validate your particular upgrade and migration path from SQL Server 2012 to SQL Server 2016.

 

  • Back up ReportServer database on source SSRS 2012
  • Back up ReportServerTempDB on source SSRS 2012
  • Backup encryption keys on source SSRS 2012
  • Stop SSRS 2016 service on target server
  • Restore ReportServer database

Note: You should see informational messages referring to the upgrade e.g .
Database 'myDB' running the upgrade step from version 849 to version 850.
Database 'myDB' running the upgrade step from version 851 to version 852.
Database 'myDB' running the upgrade step from version 850 to version 851.

  • Restore ReportServerTempDB database
  • Start SSRS 2016 service on target server. You can either start it from the: a) cmdline NET START MSSQL$MYSSRS b)services.msc  c)SSRS config tool – start by typing   rsconfigtool into the cmdline
  • Note: At this point you may get a Login failure , as the Login you are using on the new SQL Server 2016 SSRS may be different to what you were using on the SQL Server 2012. Fix this issue and create the necessary mappings between Logins and database users
  • Restore the Encryption keys

Read More on SQL Server Reporting Services

The Reporting Server Instance could not be found

SSRS migration and renaming the ReeportServer database (SQL ...

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Migrate SQL Server Reporting Services database from SSRS 2012 to SSRS 2016


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer