Blog

Access denied by business data connectivity in SharePoint 2013

Posted by Vijai Anand Blogs | SharePoint 2013 Jan 12, 2013
In this blog you will see how to resolve “Access denied by business data connectivity” when accessing the external list in SharePoint 2013.

Problem: 

In SharePoint 2013, when I tried to access the external list I was getting the following error.

 1.png


 This is because the user doesn't have the permission to the external content type.

How to resolve:

  1. Open Central Administration.
  2. Click on Manage service applications which is available in the Service Applications section.
  3. Click on BCS service application.
  4. Select the external content type, click on Set Permissions in the ECB menu.

2.png

  1. Add the user and then click on Add.

3.png

  1. Give the permissions for the user and click on Ok.

4.png

  1. Now navigate to the external list you will be able to see the data in the list.

5.png


Summary:

 Thus in this blog you have seen how to resolve “Access denied by business data connectivity” when accessing the external list in SharePoint 2013.

 

 

COMMENT USING
PREMIUM SPONSORS
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.