Access Denied by Business Data Connectivity SharePoint 2016

access denied by business data connectivity sharepoint 2016

In this post, we’re gonna fix the “Access Denied by Business Data Connectivity” issue that you may face when creating a new external content type in SharePoint 2016 and 2013.


Access Denied by Business Data Connectivity

I have created an External Content Type and External List using SharePoint Designer that has been created successfully. But when I browsed the new created external list I got the below error:

Access Denied by Business Data Connectivity

Access Denied by Business Data Connectivity

Business Data Connectivity Permission Issue

This issue usually occurs if the current user does not have sufficient permission to access the related External Content-type of this External List.

Required Permissions for Business Data Connectivity

Steps
  • Open Central Administration > Below Application Management > Click on Manage Service Applications.
Manage service applications in SHarePoint
  • Again, click on “Business Data Connectivity Service“.
  • Click on [Your External Content Type] > Set Permissions.
Permissions for Business Data Connectivity
  • Configure your entity permission by providing the BCS user administrator full permission (Edit, Execute, Selectable in Clients, and set permission).
  • After providing sufficient permission, try again to open the External List, it should now hold the data from the external data source properly.

Conclusion

In conclusion, we have provided sufficient permission for the specified user in BCS to avoid Access Denied by Business Data Connectivity issue.

Applies To
  • SharePoint 2016.
  • SharePoint 2013.
You may also like to read
Have a Question?

If you have any related questions, please don’t hesitate to ask it at deBUG.to Community.

10 thoughts on “Access Denied by Business Data Connectivity SharePoint 2016”

  1. Jordan Baratas Jordan Baratas

    you are truly a just right webmaster. The web site loading speed is
    amazing. It seems that you’re doing any distinctive trick.

    Moreover, The contents are masterpiece. you’ve performed a excellent job
    on this matter!

  2. housesignsinslate.co.uk

    Oh my goodness! Awesome article dude! Many thanks, However
    I am going through difficulties with your RSS. I don’t understand why
    I can’t join it. Is there anyone else getting similar RSS issues?
    Anybody who knows the answer will you kindly respond?
    Thanks!!

  3. What Kind Of Treatment Do I Need - Damp Proofing Or Water Proofing

    Can you tell սs moге аbout tҺіs? I’d love to fid out somе additional information.

  4. kinder pocket bike Informationen

    Hmm is anyone else encountering problems with the pictures on this blog loading?
    I’m trying to determine if its a problem on my end or if it’s the blog.
    Any responses would be greatly appreciated.

  5. Rustic dining room furnishings

    Way cool! Some very valid points! I appreciate you penning this post
    plus the rest of the site is also really good.

Leave a Reply