MS SQL Server 2008 Reporting Services for SharePoint are tricky to install, but following these steps will ease the installation pain.
- Add the SQL Admin for this SQL Server to the farm administrators of the SharePoint farm. This is important to connect to SharePoint farm with the Reporting Services.
- Install SQL Server Reporting Services on one SharePoint Farm server.
- Install the Reporting Services SharePoint Add-ins. In this case rsSharePoint_x64.msi.
If you get errors during installation, you can run Setup in files-only mode, and then run a custom actions executable after the files are copied to the server. To install the Reporting Services Add-in in files-only mode, do the following:
Run rsSharePoint_x64.msi SKIPCA=1. A files-only installation runs the Installation Wizard.
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. This configuration step will take several minutes to complete. The W3SVC service will be restarted during this process.rsCustomAction.exe /i