Wednesday, October 5, 2016

Could not load file or assembly 'Microsoft.SqlServer.Types'

A colleague contacted me to investigate a problem some of his customers had when opening an RDLC(local Reporting Services report) inside a ReportViewer control. Instead of a nice looking report, they got the following error message:

An unexpected error occurred in Report Processing. Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Strange! We had no clue why this error appeared. I don’t see a reason why this DLL is needed. Anyway we solved it by downloading the assembly through NuGet(https://www.nuget.org/packages/Microsoft.SqlServer.Types/) and including it in the installation package.

If anyone has a clue why this DLL is required, feel free to share!

Remark: Even stranger was that we hadn’t this problem with a previous release.

No comments: