Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
Migrate SQL Server Reporting Services database from SSRS 2012 to SSRS 2016
10 May,2018 by Tom Collins
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: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |