Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Posted on by RSolanke

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ronny 80 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sergio Gurrola 25 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,313 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
RSolanke 110 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Please check do you have access in reportserver as dynamics browser

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No