Solved

Sharepoint List to SQL using SSIS

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
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…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now