BCS Error – Access denied by Business Data Connectivity

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.

Leave a Reply

Your email address will not be published. Required fields are marked *