I recently ran into error message inside SSRS report manager: “SSRS Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid”.
My Setup:
Mode: Native
Authentication: Windows
So I changed the Report’s data sources properties to store the credential:
Official resource: http://msdn.microsoft.com/en-us/library/ms159736.aspx
After doing this, I was able to set up email subscriptions.
Related articles
- SQL SERVER – Data Sources and Data Sets in Reporting Services SSRS (sqlauthority.com)