Access Denied by Business Data Connectivity in SharePoint

After I creating an External Content Type and External List via SharePoint Designer , I tried to browse the new external list I got the following error:

Access Denied by Business Data Connectivity

Access Denied by BDC.png


The current user does not have a sufficient permission to access the related External Content type of this External List.


  • Central Administrator -> Application Management -> Manage Service Applications.

Manage service applications

  • Business Data Connectivity Service -> [Your External Content Type] -> Set Permissions.

BCS Set Permission

  • Configure your entity permission by giving the right user the right permission as giving the administrator a full permission (Edit, Execute, selectable in Clients and set permission).

You should be able now to browse the External list properlly.

Enjoy 🙂

9 thoughts on “Access Denied by Business Data Connectivity in SharePoint

  1. 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?


  2. Hi there I am so grateful I found your web site, I really found you by accident, while I was browsing on Askjeeve for something else, Nonetheless I am here now and would just like
    to say thanks for a remarkable post and a all round thrilling blog (I also love the theme/design),
    I don’t have time to look over it all at the moment but I
    have saved it and also included your RSS feeds, so when I have time I will
    be back to read much more, Please do keep up the fantastic b.


  3. Magnificent website. Lots of helpful info here. I am sending it
    to some pals ans additionally sharing in delicious.
    And naturally, thanks for your effort!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s