I have downloaded and installed the Sharepoint List Adapter from CodePlex from the link: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 However I am unable to connect to sharepoint site using https using Sharepoint List source I see the following error while the validation fails: Error "Error at Data Flow Task [Sharepoint List Source for RFCLists [650]]: System.ServiceModel.Security.Messag<//wbr>eSecurityException: the HTTP request was forbidden with client authentication scheme 'Ntlm' " However when i access the same sharepoint site with the HTTP instead of HttpS, it succeeds without any problem and I am able to see the data as well Is there any known documented issue while using the Sharepoint List source with htpps? If not, can you please let me what might be going wrong here? Kbuilt1

My take on this is that it probably is using the HTTPS to connect by default because SharePoint sites, well should be accessed via HTTPS. So your options are: ask your admin if there is an equivalent HTTPS address to access it, or post on the CodePlex site of the component an issue item, I trust there could be an override in the address Arthur My Blog

I posted this issue on CodePlex as well. Here's link http://sqlsrvintegrationsrv.codeplex.com/workitem/18479Kbuilt1

Hi kbuilt1, I agree with ArthurZ, this tool could not able to get Sharepoint List data through secured http, you can worked with alternate access mapping to the site, please refer to lsupailla's feed back in the link: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.