Access denied by Business Data Connectivity


In this article we will be seeing how to resolve "Access denied by Business Data Connectivity". In SharePoint 2010 when you create an External List using either SharePoint Designer 2010 or Visual Studio 2010, you may encounter "Access denied by Business Data Connectivity" error when trying to access the External List BCS List.

image1.gif

The reason is because External List requires External Content Type and External Content Type are using Business Data Connectivity services proxy to access external Data Source. With the same principle of BDC in MOSS 2007-users are required to have BDC object permission before they can use it.

Configure Business Data Connectivity access rights:

I. Go to Central Administration -> Application Management -> Manage Service Applications.

image2.gif

ii. Click on Business Data Connectivity Service.

image3.gif

iii. In the top Ribbon click on Manage.

image4.gif

iv. In Service Application Information check the corresponding External Content Type that you have used for creating the external list.

image5.gif

v. And in the top Ribbon click the Site Object Permissions.

image6.gif

vi. Site Object Permissions wizard will pop up add the account (Group or Users) and assign the permissions.

vii. Once you have configured Business Data Connectivity access rights navigate to the site and check the External List.
 

Up Next
    Ebook Download
    View all
    Learn
    View all