You may run into the error below while doing development in Visual Studio:
Could not load file or assembly ‘Microsoft.SqlServer.
Solution
You are missing SQL Server libraries that connects Visual Studio to SQL Server database. In order to fix this issue, download and install these two packages from the following URL.
- SharedManagementObjects.msi
- DB2OLEDBV5_x64.msi
Download: www.microsoft.com/en-us/download/details.aspx?id=35580
Note: The URL above is for SQL Server 2012. Download libraries for the version you use if it is not 2012 version.