Setup and Upgrade

Upgrade the Reporting Services shared service
only after all other Reporting Services components in the farm have been upgraded to SQL Server 2014.

Applies to: SQL Server 2012 | SQL Server 2012 SP1

To upgrade Reporting Services in a multi node SharePoint farm to SQL Server 2014 Reporting Services, all instances in the farm of the Microsoft SQL Server Reporting Services Add-in for SharePoint Products must be upgraded to the SQL Server
2014 version before you upgrade the Microsoft SQL Server Reporting Services Shared Service.

Report rendering will fail when the Reporting Services SharePoint shared service has been upgraded to SQL Server 2014 but other Reporting Services components in the farm are still version SQL Server 2012.

Determine where the Reporting Services Shared Service is installed:

The recommended way to determine all the servers in the farm that are running the Reporting Services shared service is to run the cmdlet getspServiceApplicationServers from
the SharePoint Management shell.

To view a specific server in SharePoint Central Administration, go to "Manage Services on Server" and look for "SQL Server Reporting Services Service”.

It is recommended you also review standby servers if the Shared service is installed and upgrade them. If a standby server contains the Reporting Services Shared service and the service is not upgraded, then when the server is brought
online into the farm, Reporting Services reports will stop rendering. If the Reporting Services service is n but not running, then the PowerShell cmdlet will not work and you will need to review the Windows Install registry for the Reporting Services service.

Determine where the Reporting Services add-in for SharePoint is installed:

On each server, use Windows Control Panel to review the list of "Programs and Features" and look for "Microsoft SQL Server RS Add-in for SharePoint". Alternatively, run the following PowerShell script: