External Content Type SQL Authentication

0Paulie
0Paulie used Ask the Experts™
on
Greetings,
Having an issue with the way that SharePoint External Content Types are authenticating to a SQL server table. Currently we have to enable NT Authority\Anonymous Login in the SQL database to allow the content to be loaded. Due to having Foundation, I can not set up a Secure Store. Is there another way to allow a particular SharePoint Group to have access to reading and writing to a connected database? We want this to be as secure as possible.

Environment:
2 SharePoint Foundation 2010 SP2 w/ February CU Servers
1 External Database Server running SQL 2008R2
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I'm afraid you cannot use sql authentication without secure store service.
You can't impersonate a windows user either.
Your choices are anonymous or to add the domain users group to SQL logins and give the required permissions to the database

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial