reporting-servicesssrs-2012ssrs-2016

SSRS Data Driven File share account - impersonation error


I am setting up SSRS data driven subscription with windows file share delivery option.

In regular SSRS subscriptions with windows file share delivery there is an option to use file share account credentials - seems that is missing in data driven subscriptions section

So, when I setup data driven subscription I am getting below error (but it works fine with regular subscription)

ERROR: Error occurred processing subscription Failure writing file : An impersonation error occurred using the security context of the current user.


Solution

  • My current job doesn't have the Enterprise edition so I haven't worked with data driven in a while. But there are Username and Password fields in the Delivery Options section that can be either hard coded or mapped to your query.

    enter image description here

    This is from SSRS2016 - YMMV.