Friday, February 24, 2012

Analysis Extension Installation in Ax 2009 Troubleshooting

While Installing the Microsoft Dynamics Ax 2009 Analysis Extension the following error has been raised which is resolved with the following solution.

ssas-ax-02
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
ssas-ax-01
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.
ssas-ax-03
I checked the GAC after uninstalling the 2005 components and I had a clean GAC, only 10.0 references.
ssas-ax-04
On to install again…and the Analysis Extensions can now be installed!

ssas-ax-05
Oh how beautiful it is:
ssas-ax-06

No comments:

Post a Comment