Access denied by Business Data Connectivity

In this article we will be seeing how to resolve "Access denied by Business Data Connectivity". In SharePoint 2010 when you create an External List using either SharePoint Designer 2010 or Visual Studio 2010, you may encounter "Access denied by Business Data Connectivity" error when trying to access the External List BCS List.

The reason is because External List requires External Content Type and External Content Type are using Business Data Connectivity services proxy to access external Data Source. With the same principle of BDC in MOSS 2007-users are required to have BDC object permission before they can use it.

Configure Business Data Connectivity access rights:

I. Go to Central Administration -> Application Management -> Manage Service Applications.