"Failed to log on to Microsoft Dynamics." in AX SSRS reports

(0) Share

Report

Posted on by Rohin

4,624

Hi,

I am getting above mentioned error while opening AX reports . I have tried all i.e by verify Business connector proxy or others solutions mentioned in others community threads having same issue , but not resolved as yet.

Even i am not able to see report view on Report manager URL. Please suggest

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Sort by

DavidGunawan 1,381 on at

Like (0)

Report
Copy link

Link copied!

Hi Visvash,

Please, check whether the AOS service account already configured as a user in the SQL reporting service.

Regards

Was this reply helpful? Yes No
André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Visvash,

Did it work before? Do you have environments where the reports are running correctly? Did you try to setup multiple AX environments on the same SSRS server?

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

thanks David,

If i am understanding you correctly, you meant that AOS service account should be added in SQL server Reporting Service > site setting > Security as system user??

please correct

Was this reply helpful? Yes No
DavidGunawan 1,381 on at

Like (0)

Report
Copy link

Link copied!

Sorry for miss-understanding. I mean is the execution service account in Reporting Services Configuration Manager.

For Reporting service > Site setting > Security, please make sure domain users group is set as system user.

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Hi David,

Please see below:

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

The AX installation guide recommends to execute the SSRS service itself under the AX Business Connector proxy account, and then on the Report Server Manager URL you have to ensure that the BC proxy account has the correct security right for the report server itself.

Also it is possible that your domain admins have forgotten to set up the account incorrectly (password does not expire, log on as a service), or the user might have been locked out due to someone trying to use it with incorrect password multiple times.

Was this reply helpful? Yes No
DavidGunawan 1,381 on at

Like (0)

Report
Copy link

Link copied!

How about the report execution service account?

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Hi David,

please see below Execution account in Reporting service configuration:

@vilmos: I have used same reporting service account as Business connector proxy account used in AX. About security rights of BC proxy account ,i have shown in attached screenshot( role as System Administrator

) in previous comment.

@Andre: Yes, we have one sandbox server and one Production server where SSRS reports are working correctly. It is sandbox2 server which is created recently by replica of Production server. And it has all same settting.

Was this reply helpful? Yes No
DavidGunawan 1,381 on at

Like (0)

Report
Copy link

Link copied!

Hi Visvash,

From the screen captures, the setting seems fine. Please check the business connector user account in active directory. Like Vimos said, there is possibility the account was setup incorrectly (password does not expire, log on as a service), or the account might have been locked out due to someone trying to use it with incorrect password multiple times.

Best regards,

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

The same BC proxy account is used for other environment and its working correctly for that so i think that would not be the case. any other suggestions?

Was this reply helpful? Yes No