locked
Errors to do with data source RRS feed

  • Question

  •  

    HI Everyone,

     

     I'm having a lot of problems after taking over from someone who has just left.

     

    In reporting services I've set up a snapshot of a report and when I go to the view tab I get a rsReportNotReady error. I suspect this is somthing to do with the data source.

     

    I opened the sln folder in Visual studio and get this error when I try to exectue the report and got this error:

     

    An error occured during local report processing. Cannot create a connection to data source 'XYZ'.
    You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configured the unattended report processing account for the report server.

     

    I've looked at the connection string properties in the data source and it's showing SQL Server authentication, I've connected to the database via the SQL Server Login credentials, and this message still comes up.

     

    Does anyone know how I can resolve this.

     

     I'd apprecaite any help.

     

    Thanks

    Wednesday, October 8, 2008 9:49 AM

Answers