Access denied by business data connectivity in SharePoint 2013

By Vijai Anand 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.

 

 

Vijai Anand

Vijai Anand has been working in IT industry for over 5 years. He holds Bachelor's degree in Electronics and Communication Engineering. Vijai write articles and blogs related to SharePoint 2013, SharePoint 2010, Silv... Read more

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs