Background: In SPS 2010 I created an External Content Type that is displaying the Customers table from a Customers database in SQL Server 2008. (I also added myself as the DBO for that database.) I configured the ECT to authenticate with the User's
Identity and to also use the Secondary Secure Store Application ID "contoso\administrators". I then added both these accounts to the Business Data Connectivity Service and granted them all four permission sets. I configured the ECT Operations to perform all
operations, and I filtered the return by limiting it to a 100 items. Using the Create List and Form wizard I then created an External List from the ECT.
Problem: When I display the External List in the browser I get this error - Access denied by Business Data Connectivity.
I have read several blogs about this issue (which seems to be common) but I still can't resolve it. Can anyone help?
Tom Molskow - SharePoint Architect -