axStart: AX 2012 and SQL 2012

[Blog bot]

Источник: http://feedproxy.google.com/~r/axsta...Jkj5E/Blog.php
==============

Last month  I updated my servers to SQL 2012. I kept the databases in SQL 2008 mode and started my AOS. Till now everything was working. Next I started an AX client still no trouble. But when the roll enter pages started the trouble starts hitting the fan. I know it should work http://blogs.msdn.com/b/dax/archive/...amics.aspxNext a look at this link http://msdn.microsoft.com/en-us/libr...=sql.110).aspx It tells us FastFirstRow is not supported anymore. Even in backwards compatible mode. Query hints FASTFIRSTROW hint OPTION (FAST n).  I know the UtilElemets is an view on SQL level. I took a closer look. I processed the view in SQL Studio So I went into the designer and removed the FastFirstRow on all places, and it works J (do the same for UtilElemetsID.)So my EP is running. The next step is Reporting Server. You have to configure the reporting server manual, because the installation of AX 2012 does not recognize SQL 2012. see http://technet.microsoft.com/en-us/l...62.aspxFinally look in the errors of the event log and add the missing dll in the Global assembly cash. So the reports are working, but when consuming an analyses data source. The error AXADOMD can’t be loaded appear, you can solve this one by installing SQL 2008 ADOMD.net I think this installation is not supported by MS anymore..But MS solved it with a fixDynamics AX Sustained Engineering is proud to announce the following compatibility between the released versions of Dynamics AX and SQL Server 2012 Microsoft Product Dynamics AX Version SQL...

This is a content summary only. Visit my website for full links, other content, and more!


Источник: http://feedproxy.google.com/~r/axsta...Jkj5E/Blog.php