Tuesday, April 29, 2014

Subscribed SSRS 2012 report fails to execute when not using default parameters

Hi Ron,


Generally, the error message means that on the report server, there is an unattended execution account specified and most likely the password expired. We always set the Unattended Execution Account if we don't want to set credentials for data sources and want the data source to work even when users are not able to enter their credentials (subscriptions or other scheduled executions.)


In your scenario, I guess the parameter may be related to the unattended execution account. We can check the parameter default value and other available values to troubleshoot this issue.


References:

Configure the Unattended Execution Account

User permission on the reporting service database server


Hope this helps.


Thanks,

Katherine Xiong




Katherine Xiong

TechNet Community Support



No comments:

Post a Comment