locked
The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM' RRS feed

  • Question

  • Hi -

    After configuring the SSIS package in the server while running we are getting the below error -

    e Utility  Version 11.0.2100.60 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  09:41:01  Error: 2015-10-21 09:41:27.06     Code: 0xC0047062     Source: 1 - Extracting Data from (SSIS Configuration)SharePoint Site SharePoint List Source [2]     Description: System.ServiceModel.Security.MessageSecurityException: The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM'. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.     at System.Net.HttpWebRequest.GetResponse()     at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)     --- End of inner exception stack trace ---    Server stack trace:      at System.ServiceModel.Channels.HttpChannelUtilities.ValidateAuthentication(HttpWebRequest request, HttpWebResponse response, WebException responseException, HttpChannelFactory factory)     at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding)     at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)     at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)     at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoap.GetListAndView(GetListAndViewRequest request)     at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.GetListAndView(String listName, String viewName)     at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.GetSharePointFields(String listName, String viewId)     at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListServiceUtility.GetFields(Uri sharepointUri, NetworkCredential credentials, String listName, String viewName)     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.GetAccessibleSharePointColumns(String sharepointUrl, String listName, String viewName)     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.ValidateSharePointColumns()     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.Validate()     at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)  End Error  Error: 2015-10-21 09:41:27.09     Code: 0xC0047017     Source: 1 - Extracting Data from (SSIS Configuration)SharePoint Site SSIS.Pipeline     Description: SharePoint List Source failed validation and returned error code 0x80131501.  End Error  Error: 2015-10-21 09:41:27.09     Code: 0xC004700C     Source: 1 - Extracting Data from (SSIS Configuration)SharePoint Site SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2015-10-21 09:41:27.11     Code: 0xC0024107     Source: 1 - Extracting Data from (SSIS Configuration)SharePoint Site      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  09:41:01  Finished: 09:41:27  Elapsed:  26.02 seconds.  The package execution failed.  The step failed.

    Can you please help me on this?

    Wednesday, October 21, 2015 8:54 AM

Answers

  • Hi Amit,

    Regarding the issue, it should occur because the NTLM identity is not passed across remote processes when NTLM authentication is used. To avoid this issue, you can try the following suggestions: 

    • In machine.config there is a tag <processModel>(read about processModel here) which let you configure IIS worker process settings. The default setting for this is <processModel autoConfig="true" />, you need to change it to <processModel userName="somedomain\someuser" password="somepassword" />.
    • If Kerberos is enabled on the server, please configure the IIS to use Kerberos instead of NTLM. To do this, set the NTAuthenticationProvider property of IIS metabase to "Negotiate" or "Negotiate,NTLM".

    Please check the below link

    http://blogs.msdn.com/ashishme/archive/2006/11/10/ntlm-vs-kerberos-windows-communication-foundation.aspx


    Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das


    • Edited by Milan Das Wednesday, October 21, 2015 9:01 AM
    • Proposed as answer by Katherine Xiong Thursday, October 22, 2015 9:11 AM
    • Marked as answer by Katherine Xiong Thursday, October 29, 2015 9:33 AM
    Wednesday, October 21, 2015 8:55 AM