In this article I will explain with an example, how to resolve the following error which occurs while using RDLC Reports in Visual Studio.
Could not load file or assembly 'Microsoft.SqlServer.Types, Version=188.8.131.52, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
The Microsoft.SqlServer.Types.dll version 11 is required for running RDLC Reports and it is not distributed with newer versions of SQL Server.
Hence in order to use RDLC Report, you will need to install the reference of this DLL.
Installing Microsoft.SqlServer.Types Version 11 Library
You will need to install the Microsoft.SqlServer.Types package using the following command.
Install-Package Microsoft.SqlServer.Types -Version 11.0.0
After successful install, open Solution Explorer and then expand the References folder and look for Microsoft.SqlServer.Types reference.
Then right click on it and select Properties. And in the Properties window, make sure that the Copy Local property is set to True.
That’s it. Now you can restart Visual Studio once and the error will be resolved.