Microsoft SQL Server 2005 Service Pack 3 is now compatible with Dynamics AX 4.0 SP2 and Dynamics AX 2009 SP1. The Dynamics AX SE team would also like to announce the availability of the latest SQL Server 2008 support packages for Dynamics AX 2009. This update now includes a fix for a variant of the “Deploy ODC Files” issue which was not addressed in the previous support pack release (KB957312-v2). This variant also affects Dynamics AX 2009 SP1 and a SP1 specific hot fix is also available.
The issue is that the business connector calls into Microsoft.Dynamics.AnalysisServices during web initialization prior to the custom resolve handler fix that was implemented with the fix for KB957312-v2. The issue is similar in that it attempts to load the SSAS 2005 library but is not found. This surfaces later as a failure when attempting to deploy the ODC file even though the custom resolve handler is loaded … because the previous resolution failure is cached. The fix which is to load the custom resolve handler prior to loading the business connector within the EP framework assembly is now available in KB957312-v3 (RTM hot fix) and KB960158 (SP1 hot fix).
AX2009 RTM SQL Support Pack (v3) [KB957312]: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;957312
AX2009 SP1 Hot fix [KB960158]: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;960158 ( KB coming soon..at the same link )
For DAX 4.0 SP2, please note the following:
Microsoft SQL Server 2008
Supported with Microsoft Dynamics AX 4.0 Service Pack 2 with kernel version 4.0.2503.358 or higher. To obtain this version, you must download the hot fix described in Knowledge Base article number 944115.
For more details on this see here. Also for more information on SQL Server Reporting Services and SQL Server Analysis Services integration with AX 2009 read up here.
For further information, feel free to contact firstname.lastname@example.org
Dynamics AX Sustained Engineering