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