Dynamics 365: Learn in doing

In Dynamics Ax 2012, Microsoft SQL Server Reporting Services (SSRS) is the primary reporting platform. So all the default preconfigured reports that are shipped with Microsoft Dynamics Ax run on the Reporting services platform. And therefore, the below installations should be done perfectly: SQL Server Reporting Services (SSRS - Part of SQL Installation) Reporting Server extensions (Business Intelligence components of Microsoft Dynamics Ax) If your installation went wrong somewhere, then there is a chance that you might get the error: Only integrated security is supported for AX queries when trying to open an report in Ax 2012. Or you might see that the report will be opened, but you will be asked to enter the username and password to proceed further. Below is the related screenshot: Solution if error occurs for a single report: Identify the Report name Open Reporting Services Configuration Manager ( All Programs > Microsoft SQL Server 2008/2012 ...

If you are working with a Dynamics Ax 2012, you would need SQL 2008/2012 to have the database in it. And if you have a Development or a Test environment, you tend to put both SQL and Dynamics Ax in the same Machine. And that is when this post can help you. I have Dev machine in my local box along side Dynamics Ax 2012 and many other applications. And even though I am not using Major applications I see that the Memory usage of my box goes real high . And I understood that this is because of Microsoft SQL. Microsoft SQL tends to eat up as much as memory it can get whenever memory is free, and thereby, causing less memory for other applications when needed. Solution for that would be to limit the Memory usage of SQL to a certain amount based on your usage of SQL. I use SQL only to store Dynamics Ax 2012's data and the memory required for SQL to manage the transactions to and forth Dynamics Ax isn't much. So I limit the memory usage of SQL server to 1024 MB and thereby incre...

What are Integration ports?   Integrations ports are basically the inbound or outbound ports through which external applications can communicate with Dynamics AOS via AIF (WCF).   The exchange of data between External/Internal application is divided into: InBound Exchange  Both Basic and Enhanced Integration ports can be used. Basically to Receive data and create in Ax OutBound Exchange  Only Enhanced Integration ports can be used. To Send data to ext. applications To Send data to ext. applications in response to their Requests   How to: Create a Basic Inbound Integration Port [AX 2012]   Basic port is used to test the operation of a custom service that does not require any data processing or exposure to the Internet. Only a developer can create a new basic integration port    To create a basic inbound port Open the Application Object Tree (AOT). Right-click the Service Groups node, and then click New Serv...