Unable to deploy AX 2012 Reporting Extensions on SQL Server 2012 Reporting Server
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