Post reply

SUBSCRIPTION: File Share "Failure writing file ...Impersonation Error

  • June 2, 2015 at 1:20 am

    #308707

    Hi All,

    I am trying to set up a File Share Subscription and I am getting below error.

    "Failure writing file \\<Server>\<Folder>\<reportname.pdf> : An impersonation error occurred using the security context of the current user"

    Below is the setup

    1) Credentials used to access Data source is stored on Report Server and is correct.

    2) Credentials given to access the Shared Path is mine and I can definitely access this Path from my Machine using run command. It is in correct UNC format. \\MachineName\Folder.

    Access to the folder is Read/Write. I can manually create and delete files on that folder.

    3) I have got login access to the Server as well.

    4) When the report is supposed to run as per the schedule, I check the ExecutionLog3 and able to see an entry with status as 'rsSuccess', RequestType as 'Subscription', Format as 'PDF'.

    Has anyone faced this issue ever? Any suggestions please. What else can I check ?

    I have checked below link which explains the process step by step. Though my Issue still persists.

    https://msdn.microsoft.com/en-us/library/ms157386.aspx

    I am using SQL Server 2008R2.

    Thanks in advance for your time and effort.

  • June 3, 2015 at 1:38 am

    #1802506

    Hi

    Did you try to use the account that is running reporting service ?

    You can see it on the configuration tool.

    This is this service that is used by the scheduler to put the file on the file share.

    Recommandation is to use an account domain.

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • June 3, 2015 at 4:55 am

    #1802539

    Hi Mohammed,

    Thanks for your input. I was planning to check this today once I get hold of those credentials which is running Reporting Services and I am sure it would work in that case. I will confirm on that later in the day.

    However, my point is - Using such a service account is not a mandatory requisite to create a Subscription. Then where is the issue.

    Upon further analysis, there is one small Issue which I need to check. This has to do with the correct permission on the folder where I want to write the Files.

    This folder, say 'Files' is in D: drive of my server, say 'MySERVER'. I have access on \\MySERVER\Files. and I can open it using Run Command from my local machine.

    Should I be able to access the folder by \\MySERVER\D$\Files ??

    As of now, I can't access \\MySERVER\D$\Files and this might be an Issue.

    If you have any idea on this please let me know.

  • June 4, 2015 at 12:26 am

    #1802880

    Even with the use of Service Account which runs the Reporting services, I was getting same Impersonation Error.

    Then the DBA gave permission to this Account for Remote Login Access to this Server. Still the same issue.

    Afterwards, when this Account was made a local admin on the server then it finally worked. I am however not convinced that one needs to be local admin for subscribing to reports. Will look more into it.

  • June 4, 2015 at 1:17 am

    #1802890

    It will be lot easier to use a domain account

    Then give the permission to the folder or shared folder

    To do this you need to change the account whom is running reporting services.

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • June 4, 2015 at 1:32 am

    #1802894

    Change the Account which is running reporting services? I don't think DBAs would want to hear that from me.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply