Report Manager - A log on error occurred when attempting to access the file share

Last Modified

Thu Apr 27 14:51 GMT 2023

Description

  • When sending reports to a file share, it may fail even if credentials are correct
  • It returns with the following error:
    • Failure writing file \\<DOMAIN>\folder\Report.mhtml: A log on error occurred when attempting to access the file share. The user account or password is not valid.

Environment

  • N-able N-central
  • Report Manager

Solution

  • If you are scheduling a report using File Share as a delivery method, and your Report Manager server is not part of the same domain as your File Share destination, you will get an error.

  • If your Report Manager server is not part of the same domain as your File Share destination, you will get this error where the "user account or password is not valid"
  • This is due to a known limitation of Microsoft SQL Server Reporting Services.
  • The server needs to be joined to the domain so that the logon access to the file share device is possible.