Access denied: Business Data Connectivity

After creating an External Content Types and connecting the ECT to a list I received the folloing error: Access denied by Business Data Connectivity

Business-Data-Connectivity-1

I created the ECT with SharePoint designer and give the correct users the correct permissions. Somehow when I saved and modified the ECT from SharePoint designer again,  the permissions got lost. I found out that if you modify the ECT in SharePoint designer you need to go back into Central Administration and set permissions again for the Business Data Connectivity Service application.

Follow these steps to give the correct permission on the ECT:

Open the  SharePoint 2010 Central Administration on the server  and click on Manage service applications.

Business-Data-Connectivity-21

Then click on Business Data Connectivity Service:

Business-Data-Connectivity-31

Select the External Content Type and click Set Object Permissions

Business-Data-Connectivity-41

Add the correct users and give them the right permissions:

Business-Data-Connectivity-61

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>