Solved

Sharepoint List to SQL using SSIS

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

17 Experts available now in Live!

Get 1:1 Help Now