SSRS Report Subscription Windows Share File Option Failed

Vinaya Velli 0 Reputation points
2024-05-24T14:47:14.9633333+00:00

We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are insufficient for performing this operation."

Kindly help us to troubleshoot and fix this issue.Permissions Screenshot.png

Subscription Error Screenshot.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,386 Reputation points
    2024-05-24T15:34:02.9833333+00:00

    The SSRS service account is the one exporting to the file share, so that service account needs write permissions on the file share.

    0 comments No comments

  2. ZoeHui-MSFT 34,576 Reputation points
    2024-05-27T02:00:26.6933333+00:00

    Hi @Vinaya Velli,

    You may need to give the read and write permission to the share folder for below account.

    If you configure the file share account, all users can select the account for any subscriptions that are configured to deliver reports to a file share. If this option is not selected, the file share account is not available on any subscriptions.

    Note, you need to verify the account you configure as the file share account has read and write permissions to any file shares users will use for file share delivery.

    The following image is what users see on subscriptions that are configured for file share delivery. The Use file share account is disabled if a file share account has not been configured.

    User's image Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


  3. ZoeHui-MSFT 34,576 Reputation points
    2024-05-30T02:37:48.9+00:00

    Hi @Vinaya Velli,

    Select the Subscription Settings option in Reporting Services Configuration Manager tool

    Checked to specify a file share account option. You need to specify a valid windows user name and password there.

    User's image

    And then use the windows file share account for a try.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments