Hardware and Software Requirements for Reporting Services in SharePoint Mode

This topic describes prerequisites, hardware requirements, and installation considerations for SQL Server 2014 Reporting Services running in SharePoint mode. Because Reporting Services SharePoint mode requires a SharePoint server, most of the requirements are based on the SharePoint environment. For native mode report servers, your hardware should meet minimum hardware and software requirements for running SQL Server 2014. For more information, see Hardware and Software Requirements for Installing SQL Server 2014.

• Prerequisites

• Report Server Database Requirements

• Power View Requirements

• More Information

Prerequisites

• For local installations, the account logged in during installation of SharePoint and Reporting Services needs to be a member of the administrators group in the local operating system. The setup account does not need to be a member of the SharePoint farm administrators group.

  For more information, see Account permissions and security settings in SharePoint 2013.

• Reporting Services running in SharePoint mode requires SharePoint Server. For more information about SharePoint requirements and configurations, see the following:

  • Hardware and software requirements (SharePoint 2013) (https://go.microsoft.com/fwlink/p/?LinkId=256365)

  • Capacity management and sizing for SharePoint Server 2013

  • Software requirements for business intelligence (SharePoint 2013)

  • Hardware and software requirements (SharePoint Server 2010)

  • Capacity management and sizing for SharePoint Server 2010

• If you want to upgrade or update existing Reporting Services SharePoint installation with SQL Server 2014, see Upgrade and Migrate Reporting Services.

• Verify the SharePoint 2013 Administration service is started in Windows Server Manager.

Report Server Database Requirements

• Both Reporting Services and SharePoint products and technologies use SQL Server relational databases to store application data.

• SQL Server 2014 Reporting Services (SSRS) requires an instance of the SQL Server Database Engine of a compatible SQL Server edition. For more information on hardware and software requirements, see Hardware and Software Requirements for Installing SQL Server 2014.

• SharePoint products can use an existing database instance. If an instance of Database Engine is not installed, the SharePoint Products Setup program installs SQL Server Express Edition for the SharePoint application databases.

• The report server instance cannot use the SQL Server Express Edition for its database. However, the SQL Server Express Edition instance installed by the SharePoint product can exist side-by-side with other Database Engine editions.

Power View Requirements

Review the most up-to-date Power View documentation on Office.Microsoft.com. Power View is a feature of Microsoft Excel 2013, and is part of the SQL Server 2014 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.

More Information

For information on SharePoint changes, see Changes from SharePoint 2010 to SharePoint 2013 (https://technet.microsoft.com/library/ff607742(office.15).aspx).

SQL Server 2014 Release Notes.