Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by 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

  • Community Member Profile Picture
    on at
    RE: AX 2012 R2 SSRS ERROR :Only integrated security is supported for AX queries

    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

  • Maqk Profile Picture
    844 on at
    RE: AX 2012 R2 SSRS ERROR :Only integrated security is supported for AX queries

    Correct answer, thanks alot Ali Zaidi

  • Verified answer
    Ali Zaidi Profile Picture
    4,655 on at
    RE: AX 2012 R2 SSRS ERROR :Only integrated security is supported for AX queries

    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.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans