Situation: Windows Server 2008 with SQL Server 2008 Reporting Services and SQL Server 2008 Analysis Services SP 1, Microsoft Dynamics Axapta 2009 with Service Pack 1 and KB 959494 will not allow AX Analysis Extensions to install with the error message: You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions.
As a new DAX-er, welcome to the hell that is DAX 2009 installer. To be kind, the setup for Ax 2009 needs a great deal of work.
Microsoft suggests applying KB 959494 which is of no use for SSAS 2008 SP1.
After applying the KB article SSAS Extensions still will not install. Further research seems to indicate that the problem might be with some 9.0 SSAS assemblies in the GAC.
Setup does not recognize that SQL Server 2008 Analysis Services is
installed If you have SQL Server 2008 Analysis Services installed and you are
installing the analysis extensions, you might receive an error that says you
must install SQL Server 2005 Analysis Services with Service Pack 2. This
error message indicates that there is an Analysis Services 2005 version of
the Microsoft.AnalysisServices.dll file in the Global Assembly Cache.
Microsoft Dynamics AX does not support running Analysis Services 2005 and
Analysis Services 2008 on the same computer. To resolve this issue, uninstall
the Microsoft.AnalysisServices.dll file that has a version number of 9.0 from
the Global Assembly Cache (typically located at C:\Windows\assembly).
Important: Be sure that you do not uninstall the
Microsoft.AnalysisServices.dll file that has a version number of 10.0
I checked and sure enough there were. So I looked and found SQL Server 2005 Express installed on the machine, not sure why.
Anyway, I uninstalled SQL Server 2005 Express and also the SQL Server 2005 Analysis Services ADOMD assemblies.
I checked the GAC after uninstalling the 2005 components and I had a clean GAC, only 10.0 references.
On to install again…and the Analysis Extensions can now be installed!
Oh how beautiful it is: