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