Sharepoint List to SQL using SSIS

Posted on 2013-01-16
Medium Priority
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'
Question by:DallasDAF
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38785949
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
LVL 14

Accepted Solution

KoenVosters earned 1500 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.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

624 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