I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a list(function Create Lists and Form).

The problem is that: I can't view data from my list. I know that SharePoint required the service SSS(Secured Store Service) for this type of connection.

Anyone can explain me, how I can resolve my problem?

The error is "access denied by business data connectivity", when I try to view my List.

I followed this istruction http://zimmergren.net/technical/access-denied-by-business-data-connectivity-solution. Now I have this error:

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:8cb329a8-e844-4403-9c1e-d7dd62ba50ae

Result of SharePoint's log file:

InnerException 1: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.SecureStoreService, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. Impossibile trovare il file specificato. File name: 'Microsoft.Office.SecureStoreService, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolea...

  • What error did you get.? Dec 3, 2013 at 10:56
  • The error is "access denied by business data connectivity".
    – ilMattion
    Dec 3, 2013 at 12:29

1 Answer 1


My problem is resolved. I follow this Link. The cause is that SharePoint 2010 Foudation don't include SSS(Secure Store Service). I have modified my ECT with a text editor.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.