Unable to load Microsoft.Data.SqlClient.SNI.X64.dll with error access is denied #3106
Open
Description
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?