Requirements for Running Reporting Services in SharePoint Integrated Mode
You can integrate Microsoft SQL Server Reporting Services with SharePoint Foundation 2010 or SharePoint Server 2010 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.
Report Server Requirements
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 R2.
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 SharePoint Server 2010 server farm, you must have at least a minimal installation of SharePoint Server 2010 on the report server computer. You cannot have a combination of SharePoint Foundation 2010 and SharePoint Server 2010 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.
SharePoint Product and Technology Requirements
The SharePoint server farm that you integrate with Reporting Services has the following edition and software requirements:
Edition requirements for the SharePoint product are SharePoint Foundation 2010 or Microsoft SharePoint Server 2010. If you use Microsoft SharePoint Server 2010, you must run either the Standard Edition or the Enterprise Edition.
Reporting Services Add-in for SharePoint Products 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 GB 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.
SharePoint 2010 products are 64-bit only. If you have a 32-bit installation of a previous version of SharePoint and Reporting Services installed in SharePoint integrated mode, you will not be able to upgrade to SharePoint 2010. For more information, review the SharePoint documentation.
Database Server Requirements
Both Reporting Services and SharePoint products use SQL Server relational databases for internal storage. SharePoint 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 R2 Reporting Services Add-in for SharePoint Products requires a SQL Server 2008 Reporting Services R2 database, because this add-in is not supported with earlier versions of SQL Server.
If you want to install Reporting Services and a SharePoint product 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.