How to: Install a SharePoint Web Front-end on a Report Server Computer
If you are configuring a report server to run in SharePoint integrated mode in a SharePoint farm, the report server needs the SharePoint object model installed. The object model can be installed on the report server by installing front-end Web server components of a SharePoint product on the report server computer.
If the SharePoint object model is not installed on the report server, you will see an error message similar to the following when you attempt connect the report server URL (http://[server_name]/reportserver): “The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded”.
A SharePoint farm consists of multiple servers that all use the same version of the SharePoint product. For example if the server farm uses SharePoint Foundation 2010, you must install SharePoint Foundation 2010 on the report server computer.
To install SharePoint components, 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 server farm.
The following steps are required only if you are deploying a report server in a SharePoint server farm. If all server applications run on a single computer, the extra step of installing the front-end Web server components on the report server is not required because you will install a full SharePoint Product as part of the single server installation.
SharePoint 2010 installation options differ from earlier versions and Web front-end is no longer a specific installation option. For SharePoint 2010 products, you select the Farm installation type and select the Complete server type. The primary difference between the Web front-end installation in SharePoint 2007 and the Complete installation in SharePoint 2010, is the number of files that are installed on the server. The services that are started automatically are identical; however the SharePoint 2010 complete installation installs more files and lets you start additional and optional services when you need them.
After you install SharePoint 2010 and join the report server computer to the farm, you can use SharePoint Central Administration to turn off the Web application service if you do not require it.
To install a front-end Web server for SharePoint 2010 products
The following procedure describes the basic steps for installing SharePoint 2010 files. For more detailed procedures, see the section ‘Install the SharePoint Products software‘ in the SharePoint topic Add a Web or application server to the farm (SharePoint Server 2010)
On the server that runs Reporting Services, run Setup for the SharePoint product used for the farm.
On Installation Types, click Server Farm.
On Server Type, select Complete.
Continue selecting the default options for the remainder of the installation steps.
After Setup is finished, you must configure the report server computer to join the SharePoint server farm.
To configure and join the Farm
The following procedure describes the basic steps for configuring SharePoint 2010 products. For more detailed procedures, see the section ‘To add the server to the farm‘ in the SharePoint topic Add a Web or application server to the farm (SharePoint Server 2010)
Run the Microsoft SharePoint 2010 Products Configuration Wizard to join the front-end Web server to the SharePoint farm. The wizard should start after Setup is finished. If it does not, start it from the Microsoft SharePoint 2010 Products group on the Start menu.
Click Next on the Welcome screen.
Click Yes to the warning that the restart of some services may be required.
On the Connect to a server farm page, click Connect to an existing server farm. Click Next.
On the Specify Configuration Database Settings page, specify the SQL Server Database Engine instance that hosts the configuration database. Click Next.
On the Specify Farm Security Settings page, type the name of the farm passphrase in the Passphrase box, and then click Next
On the Completing the SharePoint Products Configuration Wizard page, click Next.
Installing WFE components is just one step in the overall configuration process. For more information about the complete set of steps, see Configuring Reporting Services for SharePoint 2010 Integration.
For more information about how to configure a multi-server deployment that integrates Reporting Services and SharePoint products and technologies, see How to: Install and Configure SharePoint Integration on Multiple Servers.
Updated procedures to describe the SharePoint 2010 Products installation and configuration.
Added an example of the error message you will see if the SharePoint object model is not present and this procedure is needed.