Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

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′

  

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