SSIS is not using the provided custom Sharepoint credentials
Hello, I have multiple packages that need to access a Sharepoint server. So I am using the popular package from here: http://sqlsrvintegrationsrv.codeplex.com/releases The way I have it set up, is that there is a job in SQL Server that runs multiple packages every day, however when it tries to run them, it does not work. I am getting authentication and validation errors. When I run the packages locally, it works fine. After investigating, I found out that the credentials I provide to connect to Sharepoint are not used. The package uses my windows account even if I specifically set it to use custom credentials. To test this, I simply created a new account on my computer and ran the package with correct custom credentials and found that it didn't work. If I do the same on the account that has access to Sharepoint, it works. I would like to know if there is a fix or a workaround for this ? Thank you, Yan
July 24th, 2012 5:11pm

Is this a known bug or would there be something that isn't configure correctly ?
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 3:18pm

Hi Yan, Microsoft SQL Server can operate in one of two security (authentication) modes: 1. Windows Authentication Mode (Windows Authentication) 2. Mixed Mode (Windows Authentication and SQL Server Authentication) It seems that SQL Server does not support custom authentication, I would suggest you submit a feedback at http://connect.microsoft.com. Connect site is a connection point between you and Microsoft, and ultimately the larger community. Thanks, Eileen TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.
July 31st, 2012 5:46am

Hi, Thanks for the response. I am quite sure that the problem is not with SQL Server authentication. For example, if I make a SSIS package that only tries to pull data from Sharepoint and not from SQL Server, it is working when ran with an account that has access to the Sharepoint list, but fails to user the specified credentials when ran on an account that doesn't have access.
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2012 10:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics