Announcements
Hi ,
I am getting a issue while running reports in AX 2012 R2 SSRS .
I have checked all the settings of reporting configuration manager and its being authenticated by my name .
After running report I am prompted for credentials which i input but after that too i get the following errors.
"Only integrated security is supported for AX queries."
*This post is locked for comments
Dear Friend,
I try to delete as your procedure I got another error. " An error occured within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportserverdatabaseError) Get Online Help. Timeout expired. The timeout period ealpsed prior to completion of the operation or the server is not responding."
Kindly give the solution. I am struckup with this error. I need urently to print reports. If any other solution without delete the folder, just give me your help.
Expect your prompt response friends.
Thanks and Regards,
Jahir Hussain. H
Correct answer, thanks alot Ali Zaidi
If this error occurs only one report then go to http://<ServerName>:80/Reports, open Dynamics Ax reports folder and select required report and right click and click on Manage. and then from Data source from left pane and apply apply Windows integrated security and click Apply.
If this error appear on all report then you have to delete the dynamic Ax report folder which delete all report in it. then go to to Report servers form in Dynamics Ax 2012 and click on "create report folder" button to create the Folder Dynamics Ax again. Now you can open Powershell (Administrative Tools > Microsoft Dynamics Ax 2012 Management Shell). Make sure you run Powershell as Administrator. Deploy all the reports with the help of command:
Publish-AXReport -ReportName *
When you deploy all reports you will not get this message again.
André Arnaud de Cal...
294,095
Super User 2025 Season 1
Martin Dráb
232,866
Most Valuable Professional
nmaenpaa
101,158
Moderator