Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)
Suggested answer

AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

(0) ShareShare
ReportReport
Posted on by 110

HI There,

I am getting below error while running any AX report even after having all required access

":Unable to Log on to Microsoft Dynamics AX".

Note that i have set ITL\abc as business connectior a/c in AX and same a/c is used for SSRS execution account and service account while AOS service account is different.

My id has Admin access on AX, SSRS, Local server still unable to access report.

Kindly help.

*This post is locked for comments

  • Suggested answer
    Ronny Profile Picture
    Ronny 80 on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    check your BC (businness Connector) account, and your login service on SSRS server

    that should be same

  • Suggested answer
    JII SAADUDDIN Profile Picture
    JII SAADUDDIN 1,832 on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    Solutions:

    1. Browser your Report Manager > Click Folder Settings at the top > create New Role as Everyone then check all fields.

    2. continue. click Site Settings > create New Role as Everyone then check all fields.

    Godbless

  • Sergio Gurrola Profile Picture
    Sergio Gurrola 25 on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    Please check consistency values of report's parameters. maybe you have accidentally this:

    name: AX_partitionKey

    Report parameter value:Ax_CompanyName

    in this case, the report parameter value must be equal like name

    name: AX_partitionKey

    Report parameter value:Ax_partitionKey

    chek all the parameters in your datasets.

    Let me know if solve the issue.

    Regards.

  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,261 User Group Leader on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    Hi RSolanke,

    You will have to make sure that non admin users have sufficient access to browse the reports.

    If you are using SSRS in native mode you simply need to add i.e domain users as "System user" on that instance and then grant same domain group the DynamicsAXBrowser role.

    Check this link for more info:

    technet.microsoft.com/.../hh271484.aspx

    Also Check

    Setting the Reporting Services Execution Account to the same user as the Dynamics AX Service Account.

  • RSolanke Profile Picture
    RSolanke 110 on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    Yes.. i do have, not only browser but all including SysAdmin at report level.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    Please check do you have access in reportserver as dynamics browser

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012 SSRS Error - Unable to Log on to Microsoft Dynamics Ax

    verify that account used as business connector has 'log on as a service' right granted.

    regards

    Tomasz

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,579 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans