web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 R2 SSRS ERROR ...
Microsoft Dynamics AX (Archived)

AX 2012 R2 SSRS ERROR :Only integrated security is supported for AX queries

(0) ShareShare
ReportReport
Posted on by Piyush ojha 1,655

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

I have the same question (1)
  • Verified answer
    Ali Zaidi Profile Picture
    Ali Zaidi 4,657 on at

    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.

  • Maqk Profile Picture
    Maqk 844 on at

    Correct answer, thanks alot Ali Zaidi

  • Community Member Profile Picture
    Community Member on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans