You install Microsoft SQL Server 2008 R2 (including SQL Server Database Engine and SQL Server Analysis Service).
You run the PreRequisitesInstaller.exe tool from the Microsoft SharePoint Server 2010 media.
You install the SharePoint Server 2010 Enterprise Edition. Then, the SQL Server 2008 R2 installer is run again.
You continue the installation and then you reach a dialog that needs the Analysis Services SharePoint Integration feature to be installed.
In this scenario, , the installation fails and you receive the following error message:
Could not load assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.dll’
Note This issue occurs in both new server installations and existing farm installations.
This issue occurs because the installation order causes a conflict with one of the SQL Server components. The component references the Microsoft.AnalysisServices.SharePoint.Integration.dll assembly before the component is installed in the computer. When the component is installed, a conflict occurs and the system caches the error even though the file does exist.
To work around this issue, follow these methods:
Note Before you follow any of these methods, save the following code to a file that is named Setup100.exe.config.