locked
Execution account doesn't work RRS feed

  • 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.
    Tuesday, August 22, 2017 11:13 PM

All replies

  • 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 MSDNFSF@microsoft.com.


    • Proposed as answer by Henry Jiang Thursday, August 24, 2017 5:17 AM
    Wednesday, August 23, 2017 2:47 AM