Execution account doesn't work

Question

I have SSRS 2012 configured with an execution account, that is a local domain account.  I configure a data source with the option of "Credentials not required" and try to execute the report interactive or via a subscription.  Everything is all on one server. But, it always fails with "Login failed for user '' ". It appears to not be using the Execution Account that was configured.

Answer 1

Hi RJSinMO,

Regarding SSRS execution account, you must use a domain user account. To serve its intended purpose, this account should be different than the one used to run the Report Server service. 

Also, you are using "Credentials not required" for subscription, which is not supported. You have to use "Stored Credential" for the data source. It is because SSRS requires a Login to connect to the datasource to process the report when subscription will be occuring at its scheduled time. 

To create a subscription, the report must use stored credentials or no credentials to retrieve data at run time. You cannot subscribe to a report that is configured to use the impersonated or delegated credentials of the current user to connect to an external data source. For details, please see 

Subscriptions and Delivery (Reporting Services)

For detailed steps configuring SSRS execution account, you could refer to Configure the Unattended Execution Account (SSRS Configuration Manager)

Best Regards,

Henry 

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].