Webservice reports issue - urgent help needed

  • 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)

  • Run Get-wmiObject commandlet and find more details of your report server configuration.

  • 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