Upgrading Reporting Services 2017

During the upgrade, we have seen that the Reporting Services service will be uninstalled and we need to install a brand new SQL Server Reporting Services 2017, which is now a separate install and download. Before we can start with that, you need to back up your databases and the key in order to be able to migrate your reports. Databases are on your SQL Server and if you're not sure about the names, in the case of multiple Reporting Services instances, you can check the database server name and database names from the Reporting Services Configuration Manager tool, where you can click on the Database configuration page, as can be seen in the following screenshot:

To back up the key, you need to switch to the  ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.