Solved

External Content Type SQL Authentication

Posted on 2014-02-27
1
258 Views
Last Modified: 2014-04-21
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
0
Comment
Question by:0Paulie
1 Comment
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 39976753
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
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

740 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