We have an BCS issue on a Sharepoint Foundation multi-tenant farm.

Users are able to create external content types using SharePoint Designer 2010, but when they browse to the list of external data we see an error stating "Unable to display this Web Part"

In the ULS logs is see System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.SecureStoreService, Version=

Anyone have an idea?

2 Answers 2


It appears that when ECT is created using Secure Store Application ID SharePoint 2010 Foundation cannot use it, because Secure Store Service is only available in Server edition. And though I was able to create ECT I couldn't run it.

I have a blog post about creating ECT to access SQL Server database properly here:

Setting up External Content Type for SQL Server database using SQL Server authentication - SharePoint 2010 Foundation

  • Nice work Slava! I'm happy that you figured it out!
    – Anonymous
    Jun 22, 2010 at 19:51

What authentication method is being set when using SPD 2010 to create the External Content Types?


Your Answer

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