Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

System service accounts – SSRS error?

Posted on by 165

Hypothetically, is it possible a change in System service accounts (System Administration – Setup – System – System service accounts) to cause „Unable/Failed to logon to Microsoft Dynamics AX“ error while trying to connect reporting services/to generate SSRS report/?
Let’s say we have a business connector account: bproxy, not an ax user. In the reporting services configuration both “Service account” and “Execution account” match – it’s “bproxy”.
And in System service accounts users are:
1. Business connector proxy: bproxy
2. Workflow execution account & Microsoft Project Server Synchronization service account: ****** (an ax user – same for both)
Let’s say I change the Workflow execution account to “bproxy”. Is it possible that this change causes the SSRS error?
If so, how can I handle this problem and make the SSRS run properly again? And also to have the workflow configuration correct?

P.S.: Hypothetically, when I switch them back: Workflow execution account – to the ax user, not “bproxy”. And then only “bproxy” is able to generate SSRS reports.

This all without any changes to reporting server user permissions or elsewhere.
After all, I’m wondering does Workflow execution account have anything to do with Reporting server user permissions/access or something else has caused the problem?


Microsoft Dynamics AX 2012 R2.

*This post is locked for comments

  • Dick Wenning Profile Picture
    Dick Wenning 8,705 on at
    RE: System service accounts – SSRS error?

    yes that is the one, this one must be the proxy user, I had issue with ssrs reports for TFS and those where running on same SSRS instance, TFS reports dit not work any more when service account became proxy, similar issue on the OLAP server.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System service accounts – SSRS error?

    Hi Elena,

    Could you validate, you need to add :

    1. The account used to run AOS service

    2. The BC proxy account setup under "System Service accounts"

    3. The account running SSRS reporting services

    to the below groups in the  AD:

    Windows Authorization Access group

    Pre-Windows 2000 Compatibility Access group

  • E.Zgurova Profile Picture
    E.Zgurova 165 on at
    RE: System service accounts – SSRS error?

    What do you mean by that? How can I turn it on?

    According to the article you've posted everything is fine with our configuration here, I think.
    The execution account is 'bproxy' and it is a service account.

    bproxy.png

  • Dick Wenning Profile Picture
    Dick Wenning 8,705 on at
    RE: System service accounts – SSRS error?

    in that case turn on the execution account of the SSRS service,

    for more details

    msdn.microsoft.com/.../ms181156.aspx

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans