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=, 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.
Could not load file or assembly 'Microsoft.SqlServer.Types, Version=
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
Note: For more details on how to install package from Nuget, please refer my article, Install Nuget package in Visual Studio 2017, 2019, 2022.
After successful install, open Solution Explorer and then expand the References folder and look for Microsoft.SqlServer.Types reference.
Could not load file or assembly 'Microsoft.SqlServer.Types, Version=
Then right click on it and select Properties. And in the Properties window, make sure that the Copy Local property is set to True.
Could not load file or assembly 'Microsoft.SqlServer.Types, Version=
That’s it. Now you can restart Visual Studio once and the error will be resolved.