Installing the Reporting Services Add-in is one of many steps that are necessary for integrating a report server with an instance of a SharePoint product or technology. For more information about the complete set of steps, see Configuring Reporting Services for SharePoint 3.0 Integration. The order of steps for configuring the servers is important. For best results, be sure that you do them in order.

To prepare to install the Reporting Services Add-in:

1. Log on as a SharePoint farm administrator to install the Reporting Services Add-in.
   
2. Verify that you have two server installations - a report server and a SharePoint server - that meet the requirements for integrated operations. For more information, see Requirements for Running Reporting Services in SharePoint Integrated Mode.
   
3. Download the Reporting Services Add-in to a server that has an instance of the SharePoint product or technology.
   
   1. Go to the SQL Server 2008 Reporting Services Add-in for SharePoint Technologies page on the Microsoft Download Center.
      
   2. Select the language version you want to install. The Report Viewer Web Part (ReportViewer.dwp) will be available only in the language that you choose. The application pages and messages will be available in all supported languages, regardless of the language you select on the Download page. For more information about supported languages, see Solution Design Considerations for Multi-Lingual or Global Deployments (Reporting Services).
      
   3. In the Files in this Download section, click Download to install the SharepointRS.msi.
      
4. If you are integrating Reporting Services with a SharePoint farm that has multiple Web front end applications, copy or download the SharepointRS.msi to each computer in the farm that has a Web server front-end. Do this only for Web front ends that will be used to access report server content.
   

Run SharepointRS.msi on a computer that has the Web front-end for a deployment of the SharePoint product or technology that you want to configure for report server integration. You can use the Installation Wizard to install the Reporting Services Add-in, or run Setup from the command line and specify command line arguments for a files-only mode installation.

Setup does not configure the server for integration with Reporting Services. You must configure integration after Setup is complete. Setup uses the existing folder structure of the current deployment and creates a new folder for the Reporting Services Add-in application files.

1. Navigate to the folder that contains SharePointRS.msi.
   
2. Double-click SharePointRS.msi to run the Installation Wizard. The wizard displays a Welcome page, the license agreement, and a registration information page.
   
3. Click Install to run Setup.
   
4. After Setup is finished, go to Administrator Tools and click SharePoint 3.0 Central Administration.
   
5. Click Application Management. You should see a new section named Reporting Services. This section has links to pages used to specify integration settings. For instructions on how to specify the settings, see How to: Configure Report Server Integration in SharePoint Central Administration.
   

You can install the Reporting Services Add-in in files-only mode if you encountered errors during a normal Setup. In files-only mode, Setup will run the Installation Wizard to copy the application files to your computer. After the files are copied, you must run custom actions to complete the installation.

1. Run SharePointRS.msi SKIPCA=1.
   
2. Find the rsCustomAction.exe file on the file system. This file is copied to your computer by the Setup program. The file will be located in the %Temp% directory.
   To get the path information for this file, click Start, click Run, and then type %temp%. The file should be located in \Documents and Settings\<your name>\LOCALS~1\Temp.
   
3. Open a command prompt window. To do this, click Start, click Run, and type cmd.
   
4. Navigate to the folder that contains the rsCustomAction executable.
   
5. Enter the following command:
   

   	Copy Code
   rsCustomAction.exe /i

   This configuration step will take several minutes to complete. The W3SVC service will be restarted during this process.
   
6. After Setup is finished, go to Administrator Tools and click SharePoint 3.0 Central Administration.
   
7. Click Application Management. You should see a new section named Reporting Services. This section has links to pages used to specify integration settings. For instructions on how to specify the settings, see How to: Configure Report Server Integration in SharePoint Central Administration.
   

You can uninstall the Reporting Services Add-in for SharePoint Technologies by running the Setup program (SharepointRS.msi)) in uninstall mode. Uninstalling the add-in will remove server integration features that are used to process reports and models on a report server.

To uninstall the Reporting Services Add-in, you must have a Windows SharePoint Services or Office SharePoint Server 2007 installation still running. If you uninstall the SharePoint product or technology first, you must reinstall it to uninstall the Reporting Services Add-in.

1. On the SharePoint site, remove any reports and other report server items that you no longer use. They will not run after the Reporting Services Add-in is removed.
   
2. In Control Panel, in Add and Remove Programs, select Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies.
   

Click Remove.

The steps for uninstalling the add-in are the same for both stand-alone servers and server farms. Setup will remove program files and any configuration settings that were added during installation.

Setup will not remove the following:

• Logins created for the Report Server service account used to access the SharePoint configuration and content databases. You must delete any logins for the Report Server service account from the SQL Server Database Engine instance used to host the SharePoint databases.
  
• Permissions or groups that you created for report users. If you created custom permission levels or SharePoint groups to grant access to report server features, you should revoke any permissions that are no longer required.
  
• Data files that you uploaded to a SharePoint library, including report definition (.rdl), report model (.smdl), and shared data source (.rsds) files. They are not deleted, but they will no longer run. You must delete the files manually.
  
• Setup will not delete the report server database or modify the report server instance that was used for integrated operations. After you uninstall the add-in, consider switching the report server to run in native mode if you want to use the instance as a stand-alone reporting application.
  

You can run Setup from the command line to repair or uninstall the Reporting Services Add-in.

• Run SharePointRS.msi -r to repair an existing installation.
  
• Run SharePointRS.msi -u to uninstall an existing installation of the Add-in.
  

When Setup runs, it logs information to a log file in the %temp% folder for the user who is installed the Reporting Services Add-in The file name is RS_SP_<number>.log. Each error in the log starts with the string "SSRSCustomActionError".

Tasks

Concepts

Other Resources