Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
have added users name to Sql server , users cannot access the report, getting error message ,
I have give all the permission to this users, so why this users still cannot look at the report,
same time other user can access the report, on different PC, with same permission
and getting error message,
my data source configured as
An error has occurred during report processing.
cannot create a connection to data source Ax_live
for more information about this error navigate to the report server on the local server machine or enable remote errors.
can some please help me what this message means,
how can I fix this so Users can run the report , what setting I need to change .
thanks in advance
please see above the screen of the data source
Unfortunately I don't see any screenshot.
Could you give us more information? Does it happen with a single report only or all of them? Have you looked into logs? Have you already enabled remote errors?
It sounds rather as problem of the connection between SSRS and AX (AX config, Business Connector, BC proxy etc.) than permissions of AX users.
Please verify if you have SSRS services execution account set same as business connector account in Dynamics AX
You will find the SSRS services execution account, when you open SQL Reporting Services Configuration Tool
Please verify and update us with your findings.
I am new to this, can you please explain, what I will be looking for ?
some how the screenshot is not posting, I tried twice, when I hit post
it disappears , don't understand,
how can I enable remote errors ?
not familiar with this, .
just with one users cannot access the report , other users can access same report from different pc with no problem,
don't know its local pc issue or what .
any advise will be helpful.
goto url of the report server
add the user in folder setting
add the user in site setting
and open the dynamics ax folder and again add the user in folder setting of this folder
this will solve your issue
Seems to User doesn't have access or Enough permissions to access data source.
Go to event viewer on client machine and see what s the event details .
and check whether user was added to report server correctly .
Mean while refer below link to get a clue / Idea eprogrammers.blogspot.com/.../how-to-grant-user-access-to-ssrs-report.html
Thanks & Regards,
Business Applications communities