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

No comments: