Tuesday, July 05, 2011

Subscription cannot be created because the credentials used to run the report are not stored

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