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.

Are you facing any message like this?

"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"

This is an error that is easily avoided. When deploying a report to the report server we need to ensure that the data source have the credentials stored. Simply click on the data sources link in the report server web interface. Then select the data source that is being used for the report. Change the data source to stored credentials and enter in the user name and password of the user name that will be used to run the subscription. Usually this is a user name just used for subscriptions and not an actual person. The password should be set to not expire also. If the password for the user expires then your subscriptions will stop running.

If you are running a report from an OLAP cube in analysis services you will need to ensure the credentials are stored there also. The only way to connect to analysis services is with windows credentials so you will need to set up the stored credentials as above and also check the box for Use as Windows credentials. This will allow subscriptions to be created for reports pointing to analysis services.

When scheduling reports the best thing to use for security is data driven subscriptions. This allows you to use a table with the users information to give them an export of the report to a secure location. The folder locations can be locked down to just a location only the specific user can get into with active directory.

http://msdn.microsoft.com/en-us/library/ms159736.aspx

http://www.bidn.com/blogs/mikedavis/ssis/147/ssrs-subscriptions-cannot-be-created-because-the-credentials-are-not-stored