SSRS Data Driven File share account - impersonation error

Question

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.

Answer 1

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.

This is from SSRS2016 - YMMV.

Answer 2

What worked for me was to take the user that report subscription is running as add that to the execution account on SSRS config and then on the SSRS server also add that user to the local administrator group