Issue writing to SQL from Event Receiver due to security context
SharePoint
1
Posts
1
Posters
1
Views
1
Watching
-
Trying to insert into SQL table from a list event receiver. It is failing because SQL is configured to use domain security (rather than stand alone SQL security model), but the event receiver doesn't run under the loggon on user's context. We are getting error "Login failed for user NT AUTHORITY\ANONYMOUS LOGON" (nor surprisingly). Does anyone have a good solution around this - changing SQL to run in mixed mode security is not an option due to corporate policy.