Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 8 Jan 2012 8:52 AM
  • Last revision by (cMVP, Microsoft Community Contributo)
  • When: 19 Sep 2013 5:32 PM
  • Revisions: 7
  • Comments: 7
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: Access Denied By Business Data Connectivity Error in Using External Content Type List

SharePoint 2010: Access Denied By Business Data Connectivity Error in Using External Content Type List

SharePoint 2010: Access Denied By Business Data Connectivity Error in Using External Content Type List

Hi,

Recently an issue was reported to me where a site administrator tried to use a table in sql server as an external content source. He was able to create the external content type based on this and had defined all CRUD operations.
He also created a list based on this external content type however when he was trying to access this list he got this error: "Access Denied ..."

 

 

 

This was throwing an access denied error message by Business Data Connectivity. It was a clear indication of the problem and I resolved this by following/executing these steps:

1. Login into central administrator and click on "Manage Service Applications"


 

 



2.  Now click on Business Data Connectivity Services :

 

 



3. Now check the External Content Type that was created and click on Set Object Permissions:

 

 



4. Now add the user or Managed Account and grant permissions as shown and click OK and you are ready to go:

 
I hope this will help you out.

Thanks,
Rahul Rashu
I hope this will help you out.Thanks,Rahul Rashu
, , , , , , [Edit tags]
Leave a Comment
  • Please add 1 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 19 Sep 2013 5:32 PM

    Richard Mueller edited Revision 5. Comment: Modified title casing

  • 19 Sep 2013 5:31 PM

    Richard Mueller edited Revision 4. Comment: Removed tag "SPS 2010", changed tag "Has Images" to "Has Image"

  • 12 Jun 2013 4:30 AM

    Gokan Ozcifci edited Revision 3. Comment: Add data

  • 13 May 2013 3:22 PM

    Richard Mueller edited Revision 2. Comment: Removed (en-US) from title, added tags

  • 28 Feb 2012 3:28 AM

    Gokhan Ozcifci edited Revision 1. Comment: New title and design

  • 18 Feb 2012 3:53 PM

    Craig Lussier edited Original. Comment: added en-US to tags and title

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 16 Jan 2012 6:43 AM

    Thx for sharing this info

  • Posted by
    on 18 Feb 2012 3:53 PM

    Craig Lussier edited Original. Comment: added en-US to tags and title

  • Posted by
    on 28 Feb 2012 3:28 AM

    Gokhan Ozcifci edited Revision 1. Comment: New title and design

  • Posted by
    on 13 May 2013 3:22 PM

    Richard Mueller edited Revision 2. Comment: Removed (en-US) from title, added tags

  • Posted by
    on 12 Jun 2013 4:30 AM

    Gokan Ozcifci edited Revision 3. Comment: Add data

  • Posted by
    on 19 Sep 2013 5:31 PM

    Richard Mueller edited Revision 4. Comment: Removed tag "SPS 2010", changed tag "Has Images" to "Has Image"

  • Posted by
    on 19 Sep 2013 5:32 PM

    Richard Mueller edited Revision 5. Comment: Modified title casing

Page 1 of 1 (7 items)