question

Mikedelix-0579 avatar image
0 Votes"
Mikedelix-0579 asked ZoeHui-MSFT commented

SSRS 2019 File Share delivery not working

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 \\xxx.xxx.xxx.xxx\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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi,

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.
22258-annotation-2020-09-03-110257.png

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.

Regards,

Zoe



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Mikedelix-0579
May I know how is the issue going on now?

0 Votes 0 ·

Hi, if the issue has been resolved, we'd suggest click "Accept Answer" so we could achieve the case.

0 Votes 0 ·