Requirements for Running Reporting Services in SharePoint Integrated Mode

SQL Server Setup

previous page next page

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.

The following versions and editions can be used to support integrated operations:

SQL Server 2005 Reporting Services with Service Pack 2. You cannot integrate a report server instance that is running earlier versions of the software.
Supported editions include Evaluation, Standard, Developer, and Enterprise. There is no support for this feature in the Workgroup Edition or in SQL Server 2005 Express with Advanced Services.
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 or the Office Server Standard Edition.
Reporting Services Add-in for SharePoint Technologies. 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.

If your computer does not meet the requirements described in this topic, you can still access reports from a SharePoint site using Web Parts that shipped in earlier versions of Reporting Services. For more information, see Comparing Levels of Integration Across Versions of Reporting Services and SharePoint Technologies.

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 Setup. You must run Setup on the local computer; you cannot run Setup remotely to apply SP2 or install the Reporting Services Add-in.

Web Site 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 Configuring Reporting Services for SharePoint 3.0 Integration.

Authentication Provider Requirements

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.

Report Server Requirements

In addition to SP2 and edition requirements, a report server instance must have a local installation of the Windows SharePoint Services object model. To determine whether the object model is present, Setup checks the registry for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0 with Sharepoint set to Installed.

The Windows SharePoint Services object model is used to join the report server to a SharePoint farm. The object model stores a pointer to the configuration database of the SharePoint technology instance that the report server connects to. All connections from the report server to the SharePoint technology instance are made through the object model. For more information about server connections, see Security Overview for Reporting Services in SharePoint Integration Mode. For more information about how to install the object model, see How to: Install the Windows SharePoint Services Object Model on a Report Server Computer.

Requirements for the Reporting Services Add-in

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.

Editions and Versions

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.

Language Availability for Multi-Lingual Deployment Scenarios

SQL Server 2005 and SharePoint products and technologies are localized into different languages. If you integrate a report server with a SharePoint product or technology instance that is localized into a language the report server does not support, you will get a combination of languages. For more information about language support, see Deployment Modes for Reporting Services.

SQL Server Relational Databases

Both Reporting Services and Windows SharePoint Services use SQL Server relational databases for internal storage. Windows SharePoint Services installs SQL Server 2005 Express for its database. Reporting Services cannot use SQL Server Express for its database; it requires that you install the Evaluation, Developer, Standard, or Enterprise Edition of the 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.

Reporting Services has edition and version requirements for the report server database. For more information, see Creating a Report Server Database.

Operating System Requirements

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.