Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

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

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."

  • Community Member Profile Picture
    Community Member Microsoft Employee 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
    Maqk 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
    Ali Zaidi 4,657 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans