Requirements for Running Reporting Services in SharePoint Integrated Mode

You can integrate Microsoft SQL Server Reporting Services with Windows SharePoint Services or Office SharePoint Server by configuring a report server to run in SharePoint integrated mode and by installing a Reporting Services Add-in that adds infrastructure and application pages to a SharePoint Web application.

A report server that runs in SharePoint integrated mode has edition and software requirements:

  • The report server computer must satisfy the hardware and software requirements for SQL Server installations. For more information, see Hardware and Software Requirements for Installing SQL Server 2008

  • Edition requirements for Reporting Services in SharePoint integrated mode include Developer, Evaluation, Standard, or Enterprise editions. There is no support for this feature in the Workgroup edition or in SQL Server Express with Advanced Services.

  • The report server database must be created for SharePoint integrated mode.

  • To join a report server to a SharePoint farm, the report server must be installed on a computer that has an instance of a SharePoint product or technology. You can install the report server before or after installing the SharePoint product or technology instance.

  • The version of the SharePoint product or technology that you install on the report server computer must be the same version that is used throughout the farm. If you are adding a report server to a Office SharePoint Server  2007 server farm, you must have at least a minimal installation of Office SharePoint Server  2007 on the report server computer. You cannot have a combination of Windows SharePoint Services 3.0 and Office SharePoint Server  2007 in the same server farm. For more information about how to join a report server to a SharePoint farm, see How to: Install a SharePoint Web Front-end on a Report Server Computer.

The SharePoint server farm that you integrate with Reporting Services has the following edition and software requirements:

  • Edition requirements for the SharePoint product or technology are Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server  2007. If you use Microsoft Office SharePoint Server , you must run either the Standard Edition or the Enterprise Edition of Microsoft Office SharePoint Server  2007.

  • Reporting Services Add-in for SharePoint Technologies must be installed on the Web front-end. The Reporting Services Add-in provides server integration features and Web application pages for accessing report server items from a SharePoint site. The add-in must be installed on each Web front-end in the server farm through which users will access reports and other items.

  • You must have at least 2 gigabytes of RAM on the Web front-end computer.

  • Anonymous access cannot be enabled on the SharePoint Web application. If Anonymous access is enabled, you will be able to configure integration settings but users will get an error when they run a report. All other authentication providers and options are supported. If you are configuring integration between a report server and a SharePoint farm, each SharePoint Web application in the farm can be configured to use different authentication providers.

Both Reporting Services and SharePoint products and technologies use SQL Server relational databases for internal storage. Windows SharePoint Services installs the Embedded Edition for its database. Reporting Services cannot use this edition for its database; it requires that you install the Evaluation, Developer, Standard, or Enterprise edition of SQL Server Database Engine. The SQL Server 2008 Reporting Services Add-in for SharePoint Technologies requires a SQL Server 2008 Reporting Services (SSRS) report server instance because this add-in is not supported with earlier versions of SQL Server. However, the report server may connect to a report server database that is hosted in either SQL Server 2005 or SQL Server 2008.

If you want to install Reporting Services and a SharePoint technology instance on the same computer, you can run SQL Server Express and another edition of SQL Server side-by-side on the same computer or you can use the same instance of the Database Engine for the SharePoint configuration and content databases if you choose the Advanced installation option when installing a SharePoint product or technology. If you choose the Basic installation option instead, the SharePoint Setup program will install SQL Server Embedded Edition as an internal component and use that instance to host the SharePoint databases. 

Updated content

Clarified that the Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies requires a SQL Server 2008 Reporting Services (SSRS) instance of the report server, but that the database hosting the report server database may be either SQL Server 2005 or SQL Server 2008.

Community Additions