reposted from TechNet: http://msdn.microsoft.com/en-us/library/aa905869.aspx
Configuration of Reporting Services
Prior to configuring SSRS please read: How to: Configure SharePoint Integration on Multiple Servers (http://msdn.microsoft.com/en-us/library/bb677365.aspx)
1. Validate that SSRS is functioning properly by configuring it in Native Mode as a test. (You will reconfigure it in SharePoint mode later, at which time the databases for native SSRS functionality can be removed.
2. Validate the installation of the .NET Framework 3.0 on the Reporting Server
- Start the Reporting Services Configuration tool and connect to the report server instance. For instructions, see How to: Start Reporting Services Configuration (http://msdn.microsoft.com/en-us/library/ms159644.aspx http://msdn.microsoft.com/en-us/library/ms159644.aspx).
- In the navigation pane, click Service Account. Verify that it is using a domain user account. If it is not, configure it to use one.
- In the navigation pane, click Database.
- Click Change Database.
- Select Create a new database.
- Click Next.
- Specify the instance of the Database Engine that will host the database.
- Click Test Connection to verify that you can connect to it.
- Click Next.
- In Database Name, enter the desired name for the reporting services database.
- Select SharePoint Integrated Mode.
- Click Next.
- Specify credentials that the report server uses to connect to the report server database.
- Click Next.
- Click Next.
- Click Finish.
Install the Reporting Services Add-in
1. Download the Reporting Services Add-in to LTCFNF6408TRS05 (the WFE)
- Run rsSharePoint.msi SKIPCA=1.
- 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~1Temp.
- Open a command prompt window. To do this, click Start, click Run, and type cmd.
- Navigate to the folder that contains the rsCustomAction executable.
- Enter the following command: rsCustomAction.exe /i
This configuration step will take several minutes to complete. The W3SVC service will be restarted during this process.
Configure Reporting Services Add-in in Central Administration
- In Administrator Tools, click SharePoint 3.0 Central Administration.
- Click the Application Management tab.
In the Reporting Services section, you should see the following links: Manage integration settings, Grant database access, Set server defaults. If you do not see the section or the links, the Reporting Services Add-in is not installed on the computer or the feature is not activated. For more information, see How to: Activate the Report Server Feature in SharePoint Central Administration (http://msdn.microsoft.com/en-us/library/bb677366.aspx).
- Click Manage integration settings.
- In Report Server Web Service URL, specify the report server site that you want to use with the current SharePoint site or farm. The URL can point to a single report server instance, or it can be the virtual server name for a set of load-balanced report servers that run in a scale-out deployment.
<font size="