Solved

External Content Type SQL Authentication

Posted on 2014-02-27
1
254 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OneNote and SharePoint 10 61
Citrix sharefile 1 67
VBA in SharePoint 3 46
Sharepoint 2010 Auditing 4 27
A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 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