June 24, 2013 at 8:40 am
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!?!?! :crazy:
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. :crying:
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
September 5, 2013 at 8:11 pm
Run Get-wmiObject commandlet and find more details of your report server configuration.
September 6, 2013 at 3:29 am
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)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply