I have a SSRS report that runs fine. The SQL points to two databases. The SQL runs fine in SQL server.
When I upload the report to the SSRS environment I get this error message:
An error has occurred during report processing.
Query execution failed for data set 'Production'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
I use the same rds file. Any ideas why I get this error and how to resolve?