Friday, January 10, 2014

Dynamics AX 2012 - Only integrated security is supported for AX queries

Problems configuring my Reporting Server and after much time and spending hours, finally got this error message

Only integrated security is supported for AX queries


Again a question mark for me.

Finally what I did is followed the steps here on the site.

Deleting the folder and deploying all the reports again solved the issue. 

Command Line to Deploy all the report is as follows
Publish-AXReport -ReportName *


Complete copied solution


Solution if errors pops up for all SSRS Reports:

You can still apply the above approach for all the reports and it will work. But that is not the right approach for obvious reason, will take a lot of time to do that. 
More appropriate solution would be to delete all the reports and redeploy all the reports. Steps are as follows:
  1. First step is to delete all the existing SSRS Reports. For doing this you can navigate to DynamicsAx folder and delete the entire folder.
  2. Then go to Report servers form in Dynamics Ax 2012 and click on "create report folder" button to create the Folder DynamicsAx again.
  3. Now you can open Powershell (Administrative Tools > Microsoft Dynamics Ax 2012 Management Shell). Make sure you run Powershell as Administrator.
  4. Deploy all the reports with the help of command:
    Publish-AXReport -ReportName *
  5. And once, all the reports are deployed you should be good to go

No comments:

Post a Comment