Last post Oct 12, 2008 08:36 AM by Nai-Dong Jin - MSFT
Oct 08, 2008 09:12 AM|cidr77|LINK
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
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.
Oct 12, 2008 08:36 AM|Nai-Dong Jin - MSFT|LINK
From your descripton, it seems that the report was not able to connect to the datasource, right?
In the data properties tab of your report, try to make a test connection to your datasource, and you can get the detail error message accrodingly. Or what you can do is try to create a new datasource based on the datasource wizard, and in this way you can
find what is the authentication type you can use to connect to that database. If they still don't work, try to check if the current execution has the permission to connect to your database.