SQL
Analysis Services for DAX 2009 is one of the most annoying components to
install. My typical DAX installation is built on the following: Windows Server
2008 R2 with SQL Server 2008 Reporting Services and SQL Server 2008 R2,
Microsoft Dynamics Axapta 2009 with Service Pack 1 and Roll-up 7. However on
running the installation I got the following error: You must install SQL Server 2005 Analysis Services with Service Pack 2
or higher before installing the Analysis extensions.
This error
message highlights 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). Go to this
folder and remove all references to the of the Microsoft.AnalysisServices.dll
version 9.0. For more
information on removing and adding reference see this page gacutil. On running the installation once again, you get the following,
I can see
the smile on your face. Complete the installation steps and you should get the
following screen.
