AX fails to connect to Report Server in new Test domain

(0) Share

Report

Posted on by Community Member

Hello

We have a 2012 R3 CU on premises AX system that is working normally. We stood up a new TEST environment in a new Active Directory domain called TEST.LOCAL. We restored the production database and everything seems to be working except for one thing. We have AX installed on one server, and the SQL server is on a different machine. For the sake of discussion I'm going to call our production AD domain 'PROD'.

Within the AX GUI, we go to the 'Report Server Configuration' and enter everything to match the report server configuration. Then when we hit the 'Create Folder' button we get a pop up that says "The user or group name 'PROD\AX12.AOS.Service' is not recognized. This should not be, it should be 'TEST\AX12.AOS.Service'. We have looked everywhere we can think of and cannot find where to change it. It must be stored in the database and came over when we brought the database over.

Thanks in advance!!!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Maybe it is coming from the Business connector settings, did you try to change it in your AX client where Service accounts could be configured in the System administration module?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Do you mean in AX Client go to System Administration-> System -> System Service accounts?

If so, those settings look good. We have the BC proxy service set to the correct service account in the TEST domain - test\ax12.bcproxy.service

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Is your AX AOS account set to the correct domain running the service? I believe AX is trying to connect to the SSRS instance under that users' security context. You are likely using the wrong account then. If the account is correct, just check the Windows Registry for the AX Server Configuration if maybe the old account is still being referred somewhere.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The AOS service is running as the correct account in the TEST domain and is up and running normally. A search of the registry did not reveal any entries referring to the PROD account.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Use this tool to export the configuration from your TEST environment and review it. https://mathdax.codeplex.com.

Have you check this link: www.qumio.com/.../Post.aspx

Can you confirm that bc proxy account is running Reporting Services service ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The second link you posted fixed my issue - https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=10

There were several other servers in that table that needed to be removed. In case it helps someone else, here's the SQL query I used to remove the entries that needed to be deleted:

Delete FROM MicrosoftDynamicsAX.dbo.SYSSERVERSESSIONS
Where AOSID = 'SERVER.NAME';

Thanks to both of you for assistance!!!

Was this reply helpful? Yes No

Community site session details

AX fails to connect to Report Server in new Test domain

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

AX fails to connect to Report Server in new Test domain

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates