Access denied by Business Data Connectivity

When you’ve created your external list and try to access it (even as the same user, Administrator, that created it) you might get the following error:

To resolve this so called problem, follow along here:

Go to Central Administration -> Application Management -> Manage Service Applications ->Business Data Connectivity Service* -> [Your Entity] -> Set Permissions

Configure the actual permissions

In my case below, I’ve just told SharePoint that my Farm Administrator should be able to do all actions (Edit, Execute, Selectable in Clients and Set Permissions)

Please note: You might want to use different permissions in your environments – the permissions set in this blog post is just to demonstrate how you effectively change/add permissions for your BCS Entities to get up and running.

You will most likely be required to performa an IISRESET at this point to force SharePoint to understand what just happened :-)

Check your external list

You should now be able to access the external list and see the desired result.