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)


Join me on facebook and feel free to post your comments / feedback / queries.