Error installing rsSharePoint.msi on Windows 2008

When installing the rsSharePoint.msi on Windows 2008 you need to ensure you run it with "Run As Administrator".

Having said that, in multi-machine scenarios you may run into an error along the lines “Insufficient SQL database permissions for user ‘SYSTEM’ in database Sharepoint_AdminContent_<guid>….". The root cause, is on Windows 2008 or higher version OS's rsSharePoint.msi run its custom action (rscustomaction.exe) to install and active the RS feature in SharePoint as SYSTEM, which is known to fail in multi-machine scenarios.

Here is the means to workaround this issue:

  1. Open a command prompt with “Run as Administrator…”
  2. Run rsSharePoint.msi SKIPCA=1.
  3. Locate rsCustomAction.exe file on the file system. This file is copied to your computer by rsSharePoint.msi and is generally located in the %Temp% directory.
  4. Run rsCustomAction.exe /i

We are currently working on fixing this issue in rsSharePoint.msi within the SSRS 2008 R2 timeline.

 

HTH

Prash

Comments

  • Anonymous
    April 18, 2010
    Any word on a hotfix number or what cumulative update pack this fix will be contained in?? Thanks for posting something official on this!

  • Anonymous
    October 11, 2012
    Thanks for posting this i could able to install it. The only steps which was different is I copied .msi file into the <C;//users/ loggedin user name> folder & then the run specified command. It works for me. Thanks again