web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SQL Server Dependencie...
Microsoft Dynamics AX (Archived)

SQL Server Dependencies with AX 2012 R3

(0) ShareShare
ReportReport
Posted on by Konrad U 804

We are currently on AX 2012 R3 and CU9 using SQL Server 2008 looking to upgrade SQL Server.

Upon investigation it appears that SQL 2014 prereqs CU11 and SQL 2014 prereqs CU14.

I have always thought SQL Server was backwards compatible and aside from new features that can be used in the newer versions most applications would run fine on 2008, 2014 or 2016 SQL Server.

Given that the latest AX *** package still leaves a lot to fix and the difficultly of upgrading to the latest *** in production does anyone have more information on what the dependencies are or if AX 2012 R3 will function on the latest version of SQL Server?

Thanks

Konrad U

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    Last update I saw was Oct 2016.

    SQL Server 2014 Service Pack 2 is supported with the following updates:

    Office 2016 and SQL Server 2016 is supported with Microsoft Dynamics AX 2012 R3 cumulative update 11 and Dynamics AX 2012 R2 cumulative update 9.

    1. SQL Server 2016 is supported with cumulative update 9 for AX 2012 R2 with hotfix KB 3184496 and cumulative update 9 for AX 2012 R2 with hotfix KB 3184754
    2. Office 2016 is supported with cumulative update 9 for AX 2012 R2 with hotfix KB 3155797.

    The Ax system requirements doc is periodically  updated with the latest dependencies and pre-requisites -

    download https://www.microsoft.com/en-us/download/details.aspx?id=11094

    There have beens oempsots suggestignthat SQL 2-014 doe snt work as wellas 2012 with Ax

    2016 with SP1 is a big improvement so go to that release if you can.

    Master Data Management and Dynamics AX Intelligent Data Management Framework (IDMF) are both currently NOT supported with SQL Server 2016 So if using MDM and IDMF should not upgrade to SQL 2016 until Microsoft releases a patch to support it.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    AX uses most features of SQL Server not just tables, views, but stored procedures as well, so Microsoft needs to ensure that the AX kernel translates the SQL statements, table/view/fields/indexes/constraints structure, TempDB usage, security access, communication protocols, whatsoever into a language that the current version of SQL Server does understand.

    Even though the SQL Server team says their CUs are thoroughly tested and should be applied (after testing), they might change basic functionality which could make such complex systems as an ERP unstable.

    blogs.msdn.microsoft.com/.../announcing-updates-to-the-sql-server-incremental-servicing-model-ism

    So the recommendation is to sit out official announcement, or you would need to test out all business features you are currently using in AX including year-end-closing in a test environment which you have separately upgraded independent from your Production instance, to be sure.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans