SQL Server 2008 Reporting Services Add-In for MOSS 2007 installation failure..

I'm trying to get SQL Server 2008 Reporting Services Add-in for MOSS 2007 working and have everything set up, from the SQL Server side of things, to get this running.

But, while i'm trying to run the installer i'm told that the installation has been interrupted - so the installer doesn't seem to be working.

I looked at the logs on the SQL Server to see what was happening and for some reason it's trying to connect to the server as NT Authority/Anonymous - which isn't working. That was the first step and "thought" i'd located a fix for that.

What i tried was to run the following command, which only installs the files:

rsSharePoint.msi SKIPCA=1

and then move to the "Temp" folder and run:

rsCustomAction.exe /i

that threw a different error:

User: xxxxxxx
Installing Report Server feature.
Calling copyappbincontents command.

Access denied.

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensi
ons\12\bin\stsadm.exe return error code: -2147024891
Error details: System.Exception: C:\Program Files\Common Files\Microsoft Shared\
Web Server Extensions\12\bin\stsadm.exe return error code: -2147024891
   at RSCustomAction.BaseProcessLaunch.LaunchCommand(String fileName, String arg
uments, Boolean ignoreExitCode)
   at RSCustomAction.StsadmCommands.CopyAppBinContents()
   at RSCustomAction.RSFeatureSetup.Install(Boolean repair, Int32 addRetries)
Uninstalling Report Server feature.
Uninstalling Report Server feature.
Report Server feature was uninstalled.
Stopping W3SVC service.
SSRSCustomActionError: Cannot open W3SVC service on computer '.'.

Has anybody had this error before? my account is part of the local administrators group on the server and searching for that error code seems to reveal nothing either.

Any ideas?

Published Wednesday, September 03, 2008 5:25 PM by Brian Madsen
Filed under: ,

Comments

# re: SQL Server 2008 Reporting Services Add-In for MOSS 2007 installation failure..

Yeah I am having the same problem

Wednesday, September 17, 2008 9:26 AM by Marcelo Silva

# re: SQL Server 2008 Reporting Services Add-In for MOSS 2007 installation failure..

It may be possible impersonation does not work when portal is deployed as a farm. Web Front End connects to SQL as anonymous user.

Tuesday, October 07, 2008 9:01 AM by SAV

# re: SQL Server 2008 Reporting Services Add-In for MOSS 2007 installation failure..

I'm not running this on the WFE but on the main MOSS server..

however i've seen some other solutions mentioned Kerberus authentication to allow that "propagation" of the autthentication tokens..

Still working on a solution for this and as soon as i get it running i'll be posting the solution up here.

am currently battling with another problem on Team Foundation Server (again, a reporting server problem)...as soon as i get back to this i'll post more....

Thanks for the idea tho - will check it out for sure.

Tuesday, October 07, 2008 9:27 AM by Brian Madsen

# re: SQL Server 2008 Reporting Services Add-In for MOSS 2007 installation failure..

If you are running on Windows 2008 Server and you are certain that the credentails have Local Admin rights, go to the Control Panel > User Accounts and TURN OFF Account Control.

This solved my ACCESS DENIED problem on installs and command line utils

Friday, October 31, 2008 1:15 PM by Ryan Pugh