How to: Install a SharePoint Web Front-End on a Report Server Computer
If you configure a report server to run in SharePoint integrated mode in a multi-server deployment that places a report server and a SharePoint technology instance on separate computers, you must install a local instance of a SharePoint Web front-end on the report server so that you can join it to a SharePoint farm. In a multi-server deployment, the report server uses the Web front-end to connect to the SharePoint databases.
A local instance of a Web front-end is necessary only if the deployment includes multiple computers. If you deploy all server products and technologies on the same computer, you do not have to perform the steps in this topic. For more information about supported topologies, see Deployment Configurations for Reporting Services in SharePoint Integrated Mode.
To install the Web front-end, you must be a SharePoint farm administrator. You must also know the name of the database server and the configuration database that is used by the deployment of the SharePoint technology for which you are configuring report server integration.
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. If the server farm uses Windows SharePoint Services 3.0, you must install Windows SharePoint Services 3 on the report server computer. If the server farm uses Microsoft Office SharePoint Portal Server, you must install an Office SharePoint Portal Server Web front-end 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 configuring a multi-server deployment that integrates Reporting Services and SharePoint products and technologies, see How to: Configure SharePoint Integration on Multiple Servers.
To install the Web front-end
On the server that runs Reporting Services, run Setup for the SharePoint product or technology used for the farm.
On Installation Types, click Advanced.
On Server Type, select Web Front End.
The Data Location tab specifies file location for search index files. On Data Location, use the default value or choose a computer that has excess disk space.
Click Install Now.
After Setup is finished, configure the server instance and join the Web front-end to the server farm.
To configure the Web front-end
Run the SharePoint Products and Technologies Configuration Wizard to join the Web front end to the remote SharePoint farm. The SharePoint Product and Technology Configuration Wizard should start after Setup is finished. If it does not, start it from Administrative Tools.
Click Next on the Welcome screen.
Click Yes to restart the services if required.
In the Connect to a Server Farm page, select Yes to connect to an existing server farm. Click Next.
In the Specify Configuration Database Settings page, specify the SQL Server Database Engine instance that hosts the configuration database. If you do not know the name of the configuration database, click Retrieve Database Names and then select the configuration database.
Enter a user name and password that the Web front end will use to connect to the configuration database. Click Next.
In the Completing the SharePoint Products and Technologies Wizard page, click Advanced Settings.
In Advanced Settings, verify that Do not use this machine to host the Web site is selected.
Click OK, click Next, and then finish the Wizard.
Installing the Web front end is just one step in the overall configuration process. For more information about the complete set of steps, see Configuring Reporting Services for SharePoint 3.0 Integration.
How to: Configure SharePoint Integration on Multiple Servers
Reporting Services and SharePoint Technology Integration
Deployment Modes for Reporting Services
Requirements for Running Reporting Services in SharePoint Integrated Mode
Configuring Reporting Services for SharePoint 3.0 Integration