Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Webservice reports issue - urgent help needed Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 8:40 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
Hi all,

I'm trying to call a report via the web server ReportServer/ReportExecution2005.asmx?wsdl.

I've got an odd error occurring which would appear to be permissions related - but it not that simple it appears.......

I'm executing my package as a service account (let call it group\svc-myaccount). This account has access to report server and can browse and run reports via report manager. When I run the ssis package I get the following error (I've stripped out lots of unnecessary blurb):


Code: 0x00000001
Source: Render Report
Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Unable to generate a temporary class (result=1).
error CS2001: Source file 'C:\Windows\TEMP\j0qxckdq.0.cs' could not be found
error CS2008: No inputs specified

we've granted all permissions to C:\windows\temp with no success.
we've also specified the group\svc-myaccount account as a local admin and it doesn't work.....

but!..... if I run the job using my group\ADM account (which has local admin rights) it works!?!?!

So I'm a little lost - has anyone done this before - can any help?

our deadline is fast approaching, so any help would be gratefully received.


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1466770
Posted Thursday, September 5, 2013 8:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:39 PM
Points: 40, Visits: 79
Run Get-wmiObject commandlet and find more details of your report server configuration.
Post #1492025
Posted Friday, September 6, 2013 3:29 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
Hi - thanks for the reply. We resolved this issue in the end by amending the security permissions the account running the report to have modify permissions to C:\Windows\Temp on both the database server and also on the application server where reporting services sits.

Hopefully that helps anyone that has a similiar issue.

Thanks for posting your suggestion though.


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1492112
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse