Friday, December 27, 2013

You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions.

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 gacutilOn 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.