Share
ReportI'm trying to implement SSRS reports for GP. I have them deployed and I'm able to make connections to my data sources. However, whenever I run the reports
Query execution failed for dataset 'dsCompanyDetails'. (rsErrorExecutingCommand)
What I have noticed is that each failing dataset uses dynamic SQL and an EXEC statement. The dataset is different depending on which report I run but the error is the same. I've set a specific account for generating the report which helped with the old double-hop issue, and I've created a role in each of the System & Company Databases which I've granted execute permissions and added the account to that role. Not sure if I'm missing a step or if there is somewhere else I need to grant execute permissions to. The SSRS instance is different from the GP instance.
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
1