I have a scheduled job executes which executes a Stored Procedure, the SP then in turn call another SP which calls a .Net DLL method. I need SQLContext.WindowsIdentity in the DLL code in order to implement User Impersonation. I need the impersonation since only a specific user has access on a shared network directory which I intend to read.
The problem is that the scheduled job executes under NT Authority/Network Security and I get this Name in SQLContext.WindowsIdentity, while I need my specific user here. For that I have added this user as Owner of the Job as well as specified in the Job Step.
Any leads would be helpful.