Solved

Sharepoint List to SQL using SSIS

Posted on 2013-01-16
2
1,330 Views
Last Modified: 2016-02-10
I'm using SSIS to try to take in data from a Sharepoint site to SQL server.  I've managed to set up the sharepoint list adapter from codeplex.  However, when I add the address (https://sharepointsite), and the particular list I"m interested in taking in, I get the following error message:

Error at Data flow task:  [Sharepoint List Source[1]:  System.Servicemodel.Security.MessageSecurityException:  The HTTP request was forbidden with client authentication scheme 'Ntlm'
0
Comment
Question by:DallasDAF
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38785949
Hi,
which version of SharePoint and which version of SQL server?
Where do you get the error: when developing the package in Business Intelligence development studio or when executing the package from BIDS or when running the package through SQL job?
What authentication is configured in your SharePoint application (Windows, Forms, Claims,...)?

Thanks and KR
Rainer
0
 
LVL 14

Accepted Solution

by:
KoenVosters earned 500 total points
ID: 38786734
Error message clearly indicates that HTTP request was not allowed with NTLM authentication. Therefor, my first hunch would be that you need to use Kerberos authentication.

If it is configured, then something is wrongly configured as Kerberos will fallback to NTLM if Kerberos fails.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

These days socially coordinated efforts have turned into a critical requirement for enterprises.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question