asp.net web api - Calling Web API from SQL Server when API is configured to use Windows Authentication -


I have an internal web site that is protected with Windows authentication. It works correctly. I have been using the Web API in a number of ways.

Intended to automate the phone of those API methods with a SQL 2008 SSIS job. This is our favorite process so that all the defined tasks are in one place.

When I call the web API from a user's desktop that is in the appropriate Adi Security Group, the Web API call works properly but when I try to call the API from SSIS job I do, I get an error. I have tried to put a valid certificate in SSIS job but it is not working, I still get this error.

What is the security context of this job? Can I add that security reference to ad group and do all the work?

Web APIs under a different authentication process? Can this be configured in web.config or on page only?

**** Update

I have confirmed that the account I expect is calling.

I have more details on the exact error message is given:

  SSIS package "XXManagerAdd.dtsx" Start Error: 0x1 trigger API system. reflection. Target Invocation Expansion: An exception is thrown to the goal of a greeting. --- & gt; System.Net.WebException: The remote server returned an error: (401) Address SystemkNetkWebClientkOpenRead (Uri unauthorized ST_4b03489e84c44950b38aac6439e328eekcsprojkScriptMainkMain) () on --- End of inner exception stack trace - - System.RuntimeMethodHandle._InvokeMethodFast (On Object Goal, Object [] Logic, SignatureStruct & System System Properties on System, Runtime Type Handle Type Owner) on the system. Reflections: Randomiminfoine Invok (object Objh, binding Flegj Invet at, Binder binder, Object [] parameters, Kalcrinfo culture, Boolean Skip Visbiliti Czech) on the system. Reflections. Rentmem Infoin. Invok (object Objh, SystemkRuntimeTypekInvokeMember (string name, BindingFlags BindingFlags, Binder binder, Object target BindingFlags invokeAttr, Binder binder, Object [] parameters, CultureInfo culture), Object [] ProvidedArgs, ParameterModifier [] modifiers, CultureInfo culture, String [] namedParams) failed to Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript () function: trigger API SSIS package eliminates "XXManagerAdd.dtsx": success  


Comments