Cannot create a connection to data source

Why is it that sometimes I get this error and sometimes not after I deploy the same shared data souce to my Report Server?

Even if I try deleting the datasouce through Report Manager the redeploy it from VS 2005, it still errors out when I run my report. I am able to run my report fine in VS.

An error has occurred during report processing.

Cannot create a connection to data source 'mydatasourcenamehere'.

For more information about this error navigate to the report server on the local server machine, or enable remote error

Most likely the data source is configured to use Windows Integrated Security. When deployed to the report server (machine A), accessing the report from (machine B) will run into the double-hop issue when the report tries to access a data source on machine C.

-- Robert

|||

I struggled with this problem for a few hours until I figured out that I had a file system permission problem. The user running the report must have write permissions on the ../Reports directory. Once I made this change in IIS, the report ran with no errors.

I suppose this permission is required because new .aspx pages have to be created to represent the report instance in the web site's file system.

HTH,

tqheel