'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 1:[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.
Solution 2:[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
Solution 3:[3]
There are two ways to configure user for file based subscription.
If you are going with Windows user credentials, make sure the user has logon permissions and is not locked on the Server running the SSRS Service.
For File Share options as well just make sure that configured user does not have any issue logging in the SSRS Server.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Hannover Fist |
| Solution 2 | Pieter Myburgh |
| Solution 3 | M4NI5H |