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
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.
- Again, click on “Business Data Connectivity Service“.
- Click on [Your External Content Type] > Set Permissions.
- 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
- Create an External Content Type in SharePoint Designer.
- External List Limitations in SharePoint 2010/2013.
Have a Question?
If you have any related questions, please don’t hesitate to ask it at deBUG.to Community.
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!
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!!
Can you tell սs moге аbout tҺіs? I’d love to fid out somе additional information.
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.
no problem in blog images so you can check your browser settings !
Way cool! Some very valid points! I appreciate you penning this post
plus the rest of the site is also really good.