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'
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 R2Feature 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
For more info:
http://blogs.msdn.com/b/axsupport/archive/2012/06/26/unable-to-deploy-ax-2012-reporting-extensions-on-sql-server-2012-reporting-server.aspx?wa=wsignin1.0