Sharepoint 2007 Install

Question

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?

---

barryfz

Answer 1

Found this link and followed his instructions. That works. Why couldn't I just run it?

http://blog.datainspirations.com/2010/02/20/installing-reporting-services-2008-r2-in-sharepoint-integrated-mode/

---

barryfz

Answer 2

Hi Barryfz,

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.

    rsCustomAction.exe /i

References:

• Error installing rsSharePoint.msi on Windows 2008
• How to: Install or Uninstall the Reporting Services Add-in

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support

Answer 3

thanks

---

barryfz