Share via

SQL Server 2014 Reporting Services Tips, Tricks, and Troubleshooting

  • Article

This topic includes and links to information and topics to help you with installing and supporting SQL Server 2014 Reporting Services.

Setup and Upgrade

(1) To Upgrade Reporting Services in a Multi-node SharePoint farm to SQL Server 2014

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:

Get-ChildItem -Path HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall |

 Get-ItemProperty | Sort-Object -Property DisplayName |

   Select-Object -Property DisplayName, DisplayVersion, InstallLocation | where-object {$_.DisplayName -Like "*add-in*"}

**To Upgrade the add-in:
**

Run the command line installation of the rssharepoint.msi on each server, and use a files only installation.  

Msiexec.exe /i rsSharePoint.msi SKIPCA=1

For more information, see Install or Uninstall the Reporting Services Add-in for SharePoint.

To upgrade instances of the Reporting Services SharePoint Shared Service

  1. Run SQL Server 2014 setup wizard.
  2. Select "Upgrade".
  3. Select “Shared Features”.
  4. The SQL Server setup wizard automatically selects the option for all the Reporting Services shared features that are currently installed.

(2) Limitations of Side by Side Installations

SQL Server 2012 Reporting Services Native Mode cannot run side by side with either of the following:

  • SQL Server 2014 Reporting Services Add-in for SharePoint Products
  • SQL Server 2014 Reporting Services SharePoint Shared Service
  • The side by side installation prevents the SQL Server 2012 Reporting Services Native Mode Windows Service from starting. Error messages similar to the following will be seen in the Windows Event log:    

Event ID:      117 
Description: The report server database is an invalid version. 
Event ID:      107
Description: Report Server [server name] cannot connect to the report server database.

Work Around: Uninstall the Reporting Services SharePoint components and restart the Reporting Services Native Mode Windows Service.  The Reporting Services Add-in for SharePoint Products is removed from the Windows Control Panel.  For more information, see Install or Uninstall the Reporting Services Add-in for SharePoint. 

See Also