Credentials that are required to execute this report are not stored in the report server database (4236706)

Trying to create a report subscription using SQL Reporting Services produces the following error message:

"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database."

This error occurs when you create a schedule for a subscription. You can only schedule or automate report processing reports that have credentials and parameter values available to them at processing time. Reports that prompt the user for credentials or that use impersonation cannot be used in a scheduled operation.

Change the settings for the current report so that it can run unattended, and then try to create the subscription or other scheduled operation again. Use the following steps to configure a report to run unattended:


1) Go to the Data Sources properties page of the report that you want to automate.
2) For the Connect Using option, select Credentials stored securely in the report server.
3) Ensure you have a connection type and a valid connection string (ex. data source=cs-sql;initial catalog=QuestReporter).
4) In User Name and Password, type credentials that can be used to access the database. If you are using SQL Server as the data source, the user name must be valid for both logging on to the server and for accessing the database that contains the data for the report.
5)If the user name and password are credentials for a Windows account, select Use as Windows Credentials. If the credentials are for a SQL Server user login, do not select this check box.

Do not select the check box Impersonate the authenticated user after a connection has been made to the data source, regardless of authentication type. This option cannot be used for reports that run unattended.