SSRS 2019 File Share delivery not working

Mikedelix 1 Reputation point

I am standing up a stand alone SQL/SSRS server with a named instance in aws EC2. Everything is working great except for the file share delivery to an inside domain joined file server.
When using the file share account in SSRS configuration all the subscriptions error out with user or password incorrect.
I know the account works because I can map a network drive to the destination share.
I have turned up the logging to verbose and it shows nothing besides;
v VERBOSE: ServiceAppDomainController::MarkProcessAsActive - Mark the WindowsService (worker) AppDomain as active.
subscription!WindowsService_0!994!09/02/2020-13:02:09:: e ERROR: Failure writing file \\foo\reportname.xlsx : System.IO.IOException: The user name or password is incorrect.

The account running the rs service is a local domain account. Please help!

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,132 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points


    The error message shows that the user name or password is incorrect.

    I assumed the issue is related with the share account itself.

    Please check the below situations.

    1.Make sure that the file share account In the configuration manager has the correct name and password.

    2.Edit the subscription, change the credentials to "Use the following Windows user credentials" and test if the subscription will fail or not with the message of share account.

    3.Please check if the file share account has the permission to read and write of the shared folder.

    If the account did not have the account to write, the subscription will fail.

    Hope this helps!

    If you have any question, please feel free to let me know.

    If your problem has been solved, please mark "accepted answer" on my reply, thank you for your understanding.