Solved

Sharepoint List to SQL using SSIS

Posted on 2013-01-16
2
1,319 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
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Are triggers slow? 7 23
SQL Server maintenance plan 8 54
Update one rows based on previous row 5 29
Exchange - trouble forwarding mail to Distro Group 4 27
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

756 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