Friday, 3 August 2012

Installing AX 2012 with SQL Server 2012 - Model store schema creation or update failed

When trying to install Microsoft AX 2012 on Windows 2008 R2 running SQL Server 2012 I received a problem installing the Database element

The error in the Windows Application View was as follows:

AXUtil operation failed : Schema

Model store schema creation or update failed.
 

"FASTFIRSTROW" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.


To resolve a Hotfix was required to be installed and a patch copied to the updates folder where the AX 2012 Installation files are kept. This updates the AXUtil version to 6.0.1108.152

Request and download the Dynamics AX hotfix  2680186 from Microsoft using the link below.  You will need a login to the Microsoft Partnersource website

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2680186

No comments:

Post a Comment