You will get the following error while first time configuring BCS.
· Access denied by business data connectivity.
Following would be the solution.
Open Central Administration > Manage Service applications > Click Business Data Connectivity Service.
In the appearing page click on the Set Metadata Store Permissions ribbon item.
You will get the following page. Here do the following:
· Enter Everyone and click Add button
· Check all the permissions listed below
· Check the Propagate Permissions too
Click OK button.
Now retry your BCS List in SharePoint.
In this post we have explored a common error while configuring BCS & steps to resolve it.