{"id":412,"date":"2017-07-06T11:48:15","date_gmt":"2017-07-06T09:48:15","guid":{"rendered":"http:\/\/daxvisionerp.com\/?p=412"},"modified":"2025-10-27T08:32:43","modified_gmt":"2025-10-27T08:32:43","slug":"reporting-ax2012-r3-cu12-sql-server-2016","status":"publish","type":"post","link":"https:\/\/daxvisionerp.com\/home\/reporting-ax2012-r3-cu12-sql-server-2016\/","title":{"rendered":"Reporting in AX 2012 R3 CU12 with SQL Server 2016"},"content":{"rendered":"

I recently had the task to fix reporting for an AX 2012 R3 CU12 environment. The database server is SQL Server 2016.<\/p>\n

Supported?<\/h2>\n

We knew it was supported. Microsoft Dynamics AX 2012 System Requirements<\/a> document was updated in 2017 June with SQL 2016 support related information.<\/p>\n

\"\"<\/a>

Dynamics AX 2012 System Requirements SQL 2016 SMO<\/p><\/div>\n

Dynamics AX Reporting\u00a0Services Extension install crash<\/h2>\n

SSRS and AX were just not set up when I first checked. After many normal setup stuff and errors that I do not detail here, I decided to reinstall Dynamics AX Reporting Services Extension. Well, that just did not work. It\u00a0crashed\u00a0while installation or asked for inserting another disk.<\/p>\n

\"\"<\/a>

AxSetup.exe iso insert disk at report extension install<\/p><\/div>\n

\"\"<\/a>

AxSetup.exe reporting extension install crash<\/p><\/div>\n

Event log holds 2 errors at this time:<\/p>\n

    \n
  1. “Faulting application name: AxSetup.exe. … Faulting module name: KERNELBASE.dll…”<\/li>\n
  2. “The description for Event ID 139 from source Dynamics .NET Business Connector 6.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.The following information was included with the event:\n

    6.0:
    \nError 2 during access to C:\\Program Files\\Microsoft Dynamics AX\\60\\SetupSupport\\axsysHU.ktd.<\/p>\n

    The specified resource type cannot be found in the image file\u201d<\/li>\n<\/ol>\n

    Found this on LCS issue search:<\/p>\n

    \"\"<\/a>

    LCS issue<\/p><\/div>\n

    So we downloaded the package from here<\/a>\u00a0and installed Shared Management Objects x64 from it on the SQL server. We also slipstreamed this to our AX install folder KB3216898. After these, we could do the extension installation.<\/p>\n

    Sharepoint integration mode issue<\/h2>\n

    One step forward, but reports still did not work. They could be deployed, but could not be opened from AX.
    \nMessage instead of the reports: “WARNING: Make sure that SQL Server Reporting Services is installed correctly on this machine. Verify that all prerequisites are installed and services are running before installing the Business Intelligence Components for Microsoft Dynamics AX.”
    \nSame for PowerShell command: ‘Test-AXReportServerConfiguration -id Default’.
    \nValidation failed at line 20 of this method:\u00a0\\Forms\\SRSServersForm\\Methods\\checkIfSharepoint.
    \nThe call in that line which gives the error calls out of AX: isSharepoint = proxy.queryWMIForSharePointIntegratedMode(serverName, serverUrl);
    \nWell, we knew that our SSRS is in Native mode, not SharePoint integrated mode so, for now, we replaced this validation with returning false\u00a0and reports started to work (after CIL compile).<\/p>\n

    Hope this will be useful for someone out there.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    I recently had the task to fix reporting for an AX 2012 R3 CU12 environment. The database server is SQL Server 2016. Supported? We knew it was supported. Microsoft Dynamics AX 2012 System Requirements document was updated in 2017 June with SQL 2016 support related information. Dynamics AX Reporting\u00a0Services Extension install crash SSRS and AX […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"1080","footnotes":""},"categories":[23],"tags":[],"class_list":["post-412","post","type-post","status-publish","format-standard","hentry","category-ax-2012"],"_links":{"self":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/comments?post=412"}],"version-history":[{"count":1,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/412\/revisions"}],"predecessor-version":[{"id":1414,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/412\/revisions\/1414"}],"wp:attachment":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/media?parent=412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/categories?post=412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/tags?post=412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}