When I setup subscription for reports on SQL Server Reporting Services(SSRS) the following error comes up.
Error: Subscription cannot be created because the credentials used to run the report are not stored.
Solution:
1. Click your report (eg: MyInvoiceReport)
2. Click Propertise tab
3. Click DataSource on the left hand side
4. A custom data source ( If you already associated datasource it will be appear on )
5,. Connect using: choose option button Credentials stored securely in the report server
Type username and password
6. Click the check box Use as Windows credentials when connecting to the data source
Error: Subscription cannot be created because the credentials used to run the report are not stored.
Solution:
1. Click your report (eg: MyInvoiceReport)
2. Click Propertise tab
3. Click DataSource on the left hand side
4. A custom data source ( If you already associated datasource it will be appear on )
5,. Connect using: choose option button Credentials stored securely in the report server
Type username and password
6. Click the check box Use as Windows credentials when connecting to the data source