Installing Reporting Services extensions on SQL Server 2014

Hello,

When installing Reporting Services extensions on SQL Server 2014 you may run into this error:

"Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An operation is not legal in the current state. (Exception from HRESULT: 0x80131509)".

To resolve this issue you should install the following components of SQL 2008 R2 Shared Management Objects:

• Microsoft® System CLR Types for SQL Server® 2008 R2
• Microsoft® SQL Server 2008 R2 Shared Management Objects
• Microsoft® SQL Server 2008 R2 ADOMD.NET
• Microsoft® SQL Server 2008 R2 Analysis Management Objects

Go to the Microsoft® SQL Server® 2008 R2 Feature Pack download page: http://www.microsoft.com/en-us/download/details.aspx?id=16978

Then, expand "Install Instructions" to see the download links.

I hope this is helpful!

Bertrand