Have you tried to install the driver from here? Finally this seems to be a bug with .Net Framework 4.7.2 as demonstrated here.
Error : Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'

Raghava Sai Akula
396
Reputation points
Hi , I am having an legacy vb.net application which is using .net 4.7.2.
I replaced System.Data.Sqlclient with Microsoft.Data.Sqlclient(v 2.1.5) to make my application connectionstrig(password less).
I made the Microsoft.Data.Sqlclient changes in dev env and the application is loading perfectly in my localhost but in test env it throws error.
Screenshot when browsed locally with in IIS of my VM
Note : My Env is completely Azure (Azure Sql, Application in IIS in a Azure VM) and I don't have any SSMS or Sqlserver on my Azure VM. My Application is working fine in my Local Dev Env