[Resolution)] Access denied by business data connectivity)

When you access the external list created through SharePoint designer, if the error message "Access denied by business data connectivity" is displayed, you can solve the problem as follows:

Sometimes when you are creating and modifying external content types (ECT), you may see the errorAccess denied by business data connectivity.

The normal course of events when setting up an ECT is that after making sure your data source is properly configured, you use SharePoint designer to set up the ect. then, you need to give permissions to specific users and groups for that ECT. you use SharePoint 2010 Central Administration to assign those permissions.

One problem that can produce the above error message is thatModifying the ECTIn SharePoint designerClears those Permissions. If you modify the ECT in SharePoint designer, you need to go back into central administration andSet permissions again.

Of course, you can be using this error because you 've never set permissions.

The following procedure shows how to set them.

You open SharePoint 2010 Central Administration on the server that will consume the web service, and click on manage service applications.

Then you click onBusiness data connectivity Service.

Then you select the ECT and clickSet object permissions.

Then in the resultingSet object permissionsDialog box, you add yourself, or someone else, or a group, or all authenticated users, and assign them the permissions that you want to give them.

 

From: http://blogs.msdn.com/ B /ericwhite/archive/2010/06/11/access-denied-by-business-data-connectivity.aspx