Dynamics AX | 365

Microsoft Ignite Cloud Skills Challenge 2020 - Free Certification Exam

Microsoft announced a cloud challenge with the name Ignite Cloud Skills Challenge 2020 to increase awareness among technical or non-technical users for its power and cloud platform solutions, including variety of business solutions. There were also rewards such a free certification exam voucher for completing atleast one challenge, or other rewards with more challenge completions.

Ignite challenge details including Dynamics 365 platform were as follows:

Technical AX 2012 R3 - When installing AX Help Server, error appears

While installing AX 2012 R3 Help Server, an error such as below appears:

System.Runtime.InteropServices.COMException (0x80070422): The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. (Exception from HRESULT: 0x80070422)

This was due to Windows Update service was disabled, which need to be started. Whether Automatic or Manual is personal preference.

AX 2012 R3 SSRS - @SYS labels are shown in SSRS (Windows Server 2016 with SQL Server 2016) - Manually configured Reporting Extensions.

When you've configured SSRS or Reporting Extensions manually, there is chance that you could not configure everything properly. There is such situation when labels are not properly shown in SSRS reports. This can be on one side caused by Service Account not matching with AOS account, which normally should be same and is called Proxy Account. But sometimes it can be cause be a setting, mentioned in

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file.

The exact settting is as below, the tag or setting for RDCE should be enabled as True.

The below line:

<isrdceenabled>False</isrdceenabled>

Should look like as:

<isrdceenabled>True</isrdceenabled>

After changing and saving the file , you will need to restart SSRS service, and then run any SSRS report from AX 2012. The labels should be shown perfectly.

AX 2012 R3 - Reporting Extensions - Manual Installation (without AX Setup) (AX 2012 R3 CU 13 - SQL Server 2016 - Win Server 2016)

There are various occasions when for the sake of unsupported combinations of OS and ERP and its components, we need to do manual configurations. There are also certain scenarios where even supported combination of SSRS, AX and OS, we could not configure Reporting extensions using AX Setup.

We will cover in this blog post, what are the steps to do manual configurations. Since we are using SQL Server 2016 for Reporting extensions configuration, which is not supported by microsoft using AX Setup, so we have to do manual configurations. In our case, we were setting multiple SSRS instances.

First of all we have to locate the Reporting Services installation path. In our case, that was as below:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQL_UAT\Reporting Services\ReportServer

There are basically three configuration files located under the above path: rsreportserver.config, rssrvpolicy.config, and web.config which need to be changed. Besides we need to also put our SSRS dlls (dynamic link libraries) to be placed under:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQL_UAT\Reporting Services\ReportServer\bin.

Step 1: Modification in rsreportserver.config file.

Put the tag: <IsRdceEnabled>True</IsRdceEnabled> just after line: </DefaultFileShareAccount> but before </Service>.
Put following lines after the line highlighted below:

Then after </EventProcessing> ending tag, put following complete tag:

</ReportDefinitionCustomization>

Next is the rssrvpolicy.config file changes.

Insert following line, after highlighted line below:

Insert following permissionsset just before </NamedPermissionSets> ending tag:

</PermissionSet>

Next, after OXML_SDK_Strong_Name code group as highlighted below, insert many lines as below. You may need to change path:

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

</CodeGroup>

Now web.config file need to be modified. Find the line as below

Change it to:

Add following line before </httpModules> ending tag:

</httpModules>

Finally copy all dll from good installed Reporting extensions, to the following path:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQL_UAT\Reporting Services\ReportServer\bin

However, this may not be necessary as when you deploy all reports using Power Shell commands dlls will get deployed automatically.

Now restart Reporting services, for settings to take into effect.

Lastly, you can use the following command (change as per your configurations) to deploy SSRS from AOS to Reporting services, to check whether every configuration for Reporting extensions were successful. You can use AX 2012 Management Shell in Control Panel – Admin tools by Run As Admin to perform the deployment. If error occurs, please re-check every step again.

Publish-AXReport -Id SSRS_UAT –ReportName * -RestartReportServer -ServicesAOSName 02@erponebox -ServicesAOSWSDLPort 8102

Not that from AX 2012 R3, the SSRS folder was already created (Sys Admin > Setup Business Intelligence > Reporting Services > Report servers ), as that does not need any reporting extensions to be installed. The Configuration name there was used in Command above.

Page 4 of 4

Microsoft Ignite Cloud Skills Challenge 2020 - Free Certification Exam

Technical AX 2012 R3 - When installing AX Help Server, error appears

AX 2012 R3 SSRS - @SYS labels are shown in SSRS (Windows Server 2016 with SQL Server 2016) - Manually configured Reporting Extensions.

AX 2012 R3 - Reporting Extensions - Manual Installation (without AX Setup) (AX 2012 R3 CU 13 - SQL Server 2016 - Win Server 2016)

Newsletter

Youtube Training Videos

Services Provided