question

David 2 1 avatar image
David 2 1 asked

Upgrade SSRS 2014 to SSRS 2017

Hi there, I have a SQL Server 2014 instance that is currently running SQL Server Reporting Service 2014 with deployed reports. How would I be best to go about: 1. Installing a new 2017 SQL Server Reporting Service 2. Configuring new SSRS to point to the current ReportServer database on the SQL Server 2014 instance 3. Moving the deployed reports from SSRS 2014 to 2017 4. Decommission the 2014 SSRS. Basically I want the reporting services upgraded to 2017, whilst keeping the existing 2014 SQL Server instance and ReportServer database as is. TIA
ssrsmigrationreportserversql-server 2017sql-server 2014
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David 2 1 avatar image David 2 1 commented ·
Yes thanks I have read that page. However, I'm still confused as to the best method to achieve my task, so I was looking for clarity from anyone who may have completed such an endeavour.
1 Like 1 ·
WRBI avatar image WRBI commented ·
I've never done this. Have you had a look at the following page? It does mention in place upgrading of reporting services: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-2017
0 Likes 0 ·

2 Answers

·
varundevraj avatar image
varundevraj answered

Hi David, were you able to get a solution to your issue? I have a similar migration from SSRS 2012 to SSRS 2017. If you found something I am all ears...

Thanks

Varun Devaraj

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

youdont avatar image
youdont answered

The only issue I had to identify and resolve was a less obvious one that resulted in adding the extra step 7 below (for my own future reference).

Steps:

1) Back up ReportServer database
2) Back up report server encryption key
3) Uninstall Reporting Services 2014
4) Install SSRS 2017
5) Configure new instance with the same database, credentials, and certificate settings as used by the previous instance.
6) Restore encryption key.
7) Delete old key in ReportServer database that refers the old SSRS instance “MSSQLSERVER” leaving the row referring to the new instance “SSRS”
DELETE FROM keys where InstanceName ='MSSQLSERVER'
8) Test the following: Web Service URL, Web Portal URL, and reports.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.