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

Comments

Post a Comment

Popular posts from this blog

Export Data from AX 2012 - using DIXF (Data Migration Framework)

Importing is a well known task using DIXF, but at times we do need to export as well and then import it back in AX 2012. The export task can be done with the help of this information. https://technet.microsoft.com/en-us/library/dn144987.aspx Define the format of your source data Open  Data Import/Export Framework  >  Setup  >  Source data formats . Click  New , enter a name and a description, and then select  AX  from the  Type  list. Define a processing group to export data from Microsoft Dynamics AX Change the company to  CEU . In  Data Import/Export Framework , click  Common  >  Processing group , and then click  New  to create a new processing group. Set the group name to  Export-Cust  and add a description. Click  Entities  to select the entities to include in the processing group. In the  Select entities for processing g...
Read more

The virtual path maps to another application, which is not allowed

Image
During the development we came across this issue, which wasted a lot of our precious time. So I decided to share its solution with everyone. We have Project and Sub-Project Structure i.e. we have a root project and several sub-projects. The ROOT Project is entitled as TEMS8 and all other subprojects have been configured as per the image below. (Click on the image for large size) Now after setting up everything on a new Machine, we came across the Error as The virtual path maps to another application, which is not allowed Finally after investigation, we figured out that we have created multiple virtual directories which mainly causes the issue. For instance, we have another virtual directory created for DATADEF which is inside the virtual directory of TEMS8. So this was the main issue. The resolution was to remove the DATADEF Virtual Directory. Everything worked out perfectly, once we removed the inner virtual directory. We should not have something like this image below  W...
Read more

Agile Management - TFS (Priority, Stack Rank and Severity)

As per Microsoft Documentation Source http://msdn.microsoft.com/en-us/library/dd983994.aspx Priority A subjective rating of the bug, issue, task, or test case as it relates to the business. You can specify the following values: 1 :  Product cannot ship without the successful resolution of the work item, and it should be addressed as soon as possible. 2 :  Product cannot ship without the successful resolution of the work item, but it does not need to be addressed immediately. 3 :  Resolution of the work item is optional based on resources, time, and risk. Stack Rank A subjective rating of the user story, task, issue, or bug compared to other work items of the same type. An item that is assigned a lower number should be fixed before an item that is assigned a higher number. (Agile and CMMI process templates) Severity A subjective rating of the impact of a bug on the project. You can specify the following values: 1 - Critical 2 - High ...
Read more