We came across an issue where we had:

- a new server that never had Microsoft SQL Server 2008/2008 R2 or SQL Server 2012 ever installed

- we were using a Microsoft Dynamics AX 2012 Installation files from a network share to install the AX Reporting Extensions

- In the updates folder inside the installation share, we had a folder containing the extracted contents of SQL Server 2012 Compatibility hotfix

 

However the Reporting Extensions fail to install, and we get the following error in the DynamicsSetupLog.txt file:

An error occurred during setup of Reporting Services extensions.
Reason: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

  

To resolve this issue we downloaded and installed the following two components from the SQL Server 2008 R2 Feature Pack :

(1) Microsoft® SQL Server® 2008 R2 Shared Management Objects (SMO)

(2) Microsoft® System CLR Types for SQL Server® 2008 R2 (required package for SMO)

 
Both of this you can search and download from:  Microsoft® SQL Server® 2008 R2 Feature Pack - http://www.microsoft.com/en-us/download/details.aspx?id=16978

 

--author: Egil Ivar Skjold