Dynamics AX 2012 & SQL Reporting Services 2012 Reporting Extensions Error

You might come across to this error when installing Dynamics AX 2012 Reporting Services extensions on a fresh install where you never had SQL Server 2012 installed before.

We prepared a separate server for SQL Server Reporting Services 2012. We used a slipstreamed Dynamics AX 2012 Feature Pack setup to include the AX CU3 update and SQL Server 2012 Compatibility Hotfix KB2680186 . We went ahead to install Dynamics AX 2012 Reporting Services extensions on this server but installer did not finish and complained about few missing .NET assemblies.

An error occurred during setup of Reporting Services extensions.
Reason: Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0 …

Or

An error occurred during setup of Reporting Services extensions.
Reason: Could not load file or assembly ‘Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0 …

This error can be easily resolved by installing Microsoft® System CLR Types for SQL Server® 2008 R2
X86 Package(SQLSysClrTypes.msi)
X64 Package (SQLSysClrTypes.msi)
IA64 Package(SQLSysClrTypes.msi)

If you liked the story and want to see more of this kind of content, please follow our twitter handle @CursorRun or FB page @CursorRun
If you liked the story and want to see more of this kind of content, please follow our twitter handle @CursorRun or FB page @CursorRun
Default image
Rahul Sharma
Rahul is a technology enthusiast, solutions architect, trainer, and blogger, working on various Microsoft and open source solutions with more than 18 years of industry experience. He specially takes interest in designing enterprise applications, cloud integrations, IoT, and other architecture rich business solutions.

Leave a Reply

%d bloggers like this: