In this article

New: 12 December 2006

You can integrate Microsoft SQL Server 2005 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.

Server Component and Technology Requirements

Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. If you are using Office SharePoint Server , you must have the Office Server Premium Edition or the Office Server Standard Edition.

SQL Server 2005 Reporting Services with Service Pack 2 (SP2) in Developer Edition, Evaluation Edition, Standard Edition, or Enterprise Edition. There is no support for this feature in the Workgroup Edition or in SQL Server 2005 Express with Advanced Services.

SQL Server 2005 Database Engine, used to create and run application databases. Both Reporting Services and Windows SharePoint Services use SQL Server relational databases for internal storage.
If you have a Database Engine instance on a different computer, you can use it as long as the edition supports the report server database on the edition of Reporting Services you are installing. Windows SharePoint Services installs SQL Server 2005 Express for its database. Reporting Services cannot use SQL Server Express; it requires that you install the Evaluation, Developer, Standard, or Enterprise Edition of SQL Server Database Engine. 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 2005 side-by-side on the same computer. For more information, see Installing Multiple Instances of Reporting Services.
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.

Report server integration with a SharePoint server farm requires that you install an instance of the SharePoint product or technology on the report server computer. A SharePoint farm consists of multiple servers that all use the same version of the SharePoint product or technology. The instance of the SharePoint product or technology that you install on the report server must be the same version as the other nodes in the farm. For more information, see How to: Install a SharePoint Web Front-End on a Report Server Computer.

Reporting Services Add-in for SharePoint Technologies. This 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 the instance of the SharePoint technology you are using. There is only one version of the Reporting Services Add-in.

Configuration Requirements

If you are running a side-by-side deployment of both server products on the same Web server, you must create a custom Web site for the report server or configure the default Web site to run under a different port. The Web site requirements are addressed in the configuration steps. For more information, see How to: Configure SharePoint Integration on a Standalone Server.

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 running 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.

Reporting Services Add-in Requirements

The Reporting Services Add-in is installed through a Setup program that you run at a command prompt on a server that has an instance of the SharePoint product or technology you want to use. Setup performs a prerequisite check before it installs the Reporting Services Add-in to verify the edition, version, and platform requirements.

The SharePoint product or technology must be Windows SharePoint Services 3.0 or Office SharePoint Server 2007. You cannot install the Reporting Services Add-in on a pre-release version of the software. You can use the Premium or Standard edition.

When you install the Reporting Services Add-in, Setup checks whether the computer is running the x86 or x64 version of Microsoft Windows Server 2003 or later. The Itanium platform is not supported.

Hardware and Software Requirements

You must have 2 gigabytes of RAM on the computer that hosts the deployment of the SharePoint product or technology that will be integrated with a report server.

The computer must also satisfy the hardware and software requirements for each server technology. To review the requirements for SQL Server Reporting Services, see Hardware and Software Requirements for Installing SQL Server 2005. For more information about requirements for SharePoint products and technologies, search for "Determine Hardware and Software Requirements" on the Microsoft Web site.

Permission Requirements

You must be a member of the local administrators group to run SQL Server Setup and SP2 Setup. You must run Setup on the local computer; you cannot run Setup remotely to apply SP2 or install the Reporting Services Add-in. To install the Reporting Services Add-in, you must be SharePoint Farm administrator and a Site Collection administrator.