Tuesday, January 29, 2013 5:49 PM
I am trying to run rsSharepoint_x64.msi on my sharepoint 2007 server that works with a sql2008r2 instance on another box. I am logged in the the account I used as the Sharepoing setup account. This account is in the local administrators group. The account also had dbcreater and securityadmin roles in sql, I now added sysadmin. The install terminates with this error in the event logs
Insufficient SQL database permissions for user '' in database 'SharePoint_Config' on SQL Server instance 'fcm-hvsrv2012-0'. Additional error information from SQL Server is included below.
followed by a whole series of similar errors:
Insufficient SQL database permissions for user 'SYSTEM' in database 'SharePoint_AdminContent_653e4ea2-3dce-49f5-ab77-f2b758897b1e' on SQL Server instance 'fcm-hvsrv2012-0'. Additional error information from SQL Server is included below
What account is this install trying to use? What would cause this error?
Tuesday, January 29, 2013 9:55 PM
Found this link and followed his instructions. That works. Why couldn't I just run it?
Thursday, January 31, 2013 5:05 AMModerator
The issue occurs because the rsSharePoint.msi runs its custom action (rscustomaction.exe) to install and active the RS feature in SharePoint as SYSTEM on Windows 2008 or a higher version OS, which is known to fail in multi-machine scenarios.
To work around this issue, we need to install the add-in through command lines as you have performed:
1. Open a command prompt with administrator permissions.
2. Run the following command:
msiexec -i rsSharePoint.msi SKIPCA=1
3. 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.
Open a command prompt window. To do this, click Start, click Run, and type cmd. On newer operating systems, you might need to elevate your permissions and run this run this with administrator permission.
4. Navigate to the folder that contains the rsCustomAction executable.
5. Enter the following command. This configuration step will take several minutes to finish. The W3SVC service will be restarted during this process.
- Error installing rsSharePoint.msi on Windows 2008
- How to: Install or Uninstall the Reporting Services Add-in
If you have any feedback on our support, please click here
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, February 03, 2013 4:55 PM
Friday, February 22, 2013 9:26 PMthanks