Unable to load Microsoft.Data.SqlClient.SNI.X64.dll with error access is denied

[uch-fhlb]

Project Type: MVC
.Net Framework version 4.8
Server 2019

We are having an inconsistent problem on some of our servers. We can't explain why the the access request is read in some instances and execute in others. This is causing access to the dll to be denied. Using ProcessMon we were able to see that Execute/Traverse permission is being requested on one server while Generic Read is being requested on the other. We have been unable to determine why this is happening.

In the SqlClient troubleshooting guide, it says execute permissions are needed when using .net core. It doesn't appear that that permission is necessary for .net framework. Do we need to grant execute permissions? Or is there another workaround that we could implement?

[mdaigle]

Hi @uch-fhlb, we don't have any specific guidance from the driver perspective. The security context management is handled by .NET for loading dlls. The driver is just trying to load the dll from wherever you deployed your application. For example, one common issue we've seen is loading from a network location.

If you have any additional details about the error that point to an issue with MDS, please post them here. Thanks!