scubaal wrote:
> Three boxes involved:
>
> BoxA: MOSS + SQL2005 + Reporting Services + MOSS integration add-in
> BoxB (act01projsrv01): SQL2k + SPS + Project server
> BoxC: XP workstation
>
> Objective: Run reports in MOSS library against Project server on BoxB
> on XP workstation.
>
> All bits are working on each box:)
>
> Scenario a:
>
> Logon to BoxA via RDP and connect to MOSS via browser.
> Open reports library.
> Create Datasource as:
> Data source type: SQL Server
> Connection string: data source=act01projsvr01;initial
> catalog=ProjectServer
> Creates ok.
>
> Create Report builder model. Takes a very long time. Eventually times
> out - but the model is there in the MOSS library. error message=
> Server was unable to process request. ---> The operation has timed
> out
>
> Create report using datasource and model. Report created ok, can
> create and use data from tables on the BoxB (Projectserver).
>
> Scenario b:
> Move to XP workstation.
> All objects (Datasource, Report model and report) can be accessed
> through MOSS library
> BUT
>
> when report is run it fails with:
>
> An error has occurred during report processing.
> Cannot create a connection to data source 'dataSource1'.
> For more information about this error navigate to the report server on
> the local server machine, or enable remote errors
>
> ....but the report DOES run on the local server (BoxA). So there is
> obviously some permissions issue between the XP workstation passing
> through the MOSS server to the SQL2k server......but how on earth can
> I find out what?
>
> BTW everything is setup to use windows authentication and we are
> 2003AD throughout.
>
> Suggestions appreciated.
>
> Al.