How to: Install the Windows SharePoint Services Object Model on a Report Server Computer

SQL Server Setup

If you are configuring a report server to run in SharePoint integrated mode in a distributed server deployment that places a report server and a SharePoint technology instance on separate computers, you must install a local instance of the Windows SharePoint Services 3.0 object model for a farm installation on the report server computer. In a distributed server deployment, the report server uses the object model to access the SharePoint databases.

The object model cannot be installed as a separate component. However, you can install a Web front end to join the report server to a SharePoint farm. Configuring the Web front end provides connection information that the report server uses to connect to the farm.

Note:
A local instance of the object model is necessary only if you are integrating the server products in a distributed server topology that places each server on a separate computer. If you are integrating a report server and a SharePoint product or technology on the same computer (that is, the two server technologies will run side-by-side), you do not have to install the Web front end.

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.

To install the Windows SharePoint Services object model

  1. On the server that runs Reporting Services, run Setup for Windows SharePoint Services 3.0.

  2. On Installation Types, click Advanced.

  3. On Server Type, select Web Front End.

  4. Click Install Now.

To configure the Windows SharePoint Services object model

  1. Run the SharePoint Products and Technologies Configuration Wizard to join the Web front end to the remote SharePoint farm.

  2. In the Connect to a Server Farm page, select Yes to connect to an existing server farm. Click Next.

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

  4. Enter a user name and password that the Web front end will use to connect to the configuration database. Click Next.

  5. In the Completing the SharePoint Products and Technologies Wizard page, click Advanced Settings.

  6. In Advanced Settings, verify that Do not use this machine to host the Web site is selected.

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

See Also