Sunday, July 9, 2023

SSRS Error - Credentials used to run the report are not stored

This issue comes when implement automated process like subscriptions e.g. Email subscription, File Share Subscription, Data Driven Subscription. Report Snapshot or Report Caching

For all of these automated SSRS processes,  it is mandatory to store the credential securely in the report server. This credential works as an unattended account to perform unattended tasks like subscription, caching schedule etc.

We will get this error because we may not have stored our credential in the report server. Check the data source properties of particular report for credential information. Store the credential in the data source and this issue will be resolved.

We can get report in email or file share by using report subscription. Follow the below links for more information:

Report schedule: http://www.sqlcircuit.com/2012/11/ssrs-how-to-create-shared-schedule-and.html
Email Subscription: http://www.sqlcircuit.com/2012/10/ssrs-how-to-create-email-subscription.html
File Share Subscription: http://www.sqlcircuit.com/2012/10/ssrs-implementation-of-file-share.html

1 comment: