SSRS 2008 SharePoint Add in installation on Windows Server 2008 Howto

At a client SharePoint 2007 farm, installed on Windows Server 2008 servers, I had to install SQL Server Reporting Services Add in for Sharepoint. I already know that one has to install with elevated privileges at 2008 but this installation required some specific steps to complete.

At first I tried this installation:

1. Open a command prompt with elevated privileges (run as administrator)
2. Run this command: msiexec /i “<path to msi>\rsSharePoint_x64.msi”

But this did not work. The installation failed and did a roll back. In the log file (%temp%\RS_SP_0.log) there was logged:

User: SYSTEM
Installing Report Server feature.
SSRSCustomActionError: SharePoint is installed, but not configured.

Also in the SQL logs there was an error: “login failed for user: <domain>\machine account$”

So the CustomAction generated an error. After some searching on the internet I found some info that finally led to the correct installation. You have to install SSRS 2008 Add in as follows:

1. Open a command prompt with elevated privileges
2. Run this command: msiexec /i “<path to msi>\rsSharePoint_x64.msi” SKIPCA=1
3. Open Start > Run, type %temp% to open your temp directory and check if there is a file in there called rsCustomAction.exe
4. Again in the command prompt, go to the temp directory and run this command: rsCustomAction.exe /i. See the screenshots about what happens next.

Execute this installation on every WFE in your SharePoint farm and the Add in will be installed.

Tags: Howto, installation, Report Server