Does SQL server 2016 support Reporting and Analysis services in AX 2012 R3 CU11?

(0) Share

Report

Posted on by Abbas Ithayathullah

175

Hi,

I have already installed Ax 2012 R3 CU 11 and SQL 2016 SP1. When I try to install Analysis and Reporting Services components received the below error saying install supported SQL version. I tried to install Connector for Microsoft Dynamics Ax received the same error. Then I got this like which shows that SQL 2016 doesn't support DIXF but we can if we install the specified KB. But I installed SQL 2016 SP1 (which included all the fix including the KB) https://community.dynamics.com/ax/f/33/t/210097. Does anyone help me to resolve this issue?

0486.Error.jpg

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Have you opened the required firewall ports? It is needed in order to discover the services.

Was this reply helpful? Yes No
Abbas Ithayathullah 175 on at

Like (0)

Report

Hi Vilmos Kintera,

Thanks for your prompt response.

Firewall is off in SQL server. Is there any other place I have to check?

Br Abbas

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Check your AX AOS and the SSRS / SSAS instances too. It is usually the firewall that blocks installing such components.

Was this reply helpful? Yes No
Abbas Ithayathullah 175 on at

Like (0)

Report

I agree, but in my case both server firewall is in off mode.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Is the installer which you have used slipstreamed, so does it have the same patch level (CU11) kernel hotfix in the Updates folder? If not, then try to add the kernel hotfix of the CU to have a slip-stream installer and check if that makes any difference.

Was this reply helpful? Yes No
Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

Is the issue resolved?

Was this reply helpful? Yes No
Verified answer

Abbas Ithayathullah 175 on at

Like (0)

Report

Hi Umash,

Actually I down graded to lower version of SQL which resolved my issue.

Br Abbas

Was this reply helpful? Yes No
Suggested answer

Mostafa Mohie 10 on at

Like (0)

Report
Reporting SQL server 2016 issue solved using the below Prerequisite :

SQL Server 2016 “ last update “

KB3184496 include to "AX" installation source iso

1.       Remove Reporting extensions.

2.       Install below components from link  https://www.microsoft.com/en-us/download/details.aspx?id=35580

a)      Microsoft® SQL Server® 2012 SP1 Shared Management Objects ( SharedManagementObjects.msi)

b)      Microsoft® SQL Server® 2012 SP1 Analysis Management Objects ( SQL_AS_AMO.msi)

3.       Restart server.

4.       Reinstall AX Reporting extensions.

Regrads,

Mostafa Mahmoud

Was this reply helpful? Yes No