Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Automated SSRS report question

Posted on by 250

We have a few SSRS reports that are set up to automatically run on the 1st day of each month.  No changes to the reports but they are not being saved to the shared folder specified (that hasn't changed either).  On the Subscriptions page in Report Builder, the following error message appears:  

 â€˜Failure writing file \\adcfs11\elc\shared\Corporate\Finance\Automated Scheduled Reports\GP Users by Company and Roles\GP Users by Company and Roles 2021_11_01_084541.xlsx : A log on error occurred when attempting to access the file share. The user account or p’

The message stops there and I get no further information

 

Nothing in SSRS changed – looking to get more info…..

 

Categories:
  • Suggested answer
    Craig Fuller Profile Picture
    Craig Fuller 409 on at
    RE: Automated SSRS report question

    If you have the permissions, you can just Manage the report on the reports server and update the credentials used with your own as well.

  • Suggested answer
    Craig Fuller Profile Picture
    Craig Fuller 409 on at
    RE: Automated SSRS report question

    You would need to create a dedicated account used for running the reports (usually termed a 'service' account). When we create reports we use this specific AD user account that acts as a user for our SSRS reporting needs, doesn't have a password that expires and cannot be changed. The user is granted all network, folder and database object access necessary to run reports and distribute as needed. However, I work in the IT Department and we do not give this service account credentials out to anyone outside of IT...so this may have to be adjusted to work in your environment.

    I hope this helps.

  • Deanne CWCO Profile Picture
    Deanne CWCO 250 on at
    RE: Automated SSRS report question

    The person who's account is listed as the owner and in the credentials box did have to reset their password.  This person will not be with the company much longer (I'm their replacement).  What has to be done to ensure that this (and some other SSRS reports) will run as scheduled?  The reports are used for audit purposes.

  • Suggested answer
    Craig Fuller Profile Picture
    Craig Fuller 409 on at
    RE: Automated SSRS report question

    I assume the user account used is an AD account? It is saying that it is unable to access the file share.

    Check that the account is not disabled, locked out and that it still has permissions to write to the specified folder location.

    You can also logon to a PC with that account and navigate to the folder path you have listed to confirm it has permissions to the file share.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans