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
Leave a Comment
  • Please add 2 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 5. Comment: Modified title casing

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

  • Gokan Ozcifci edited Revision 3. Comment: Add data

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

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

  • 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
  • Thx for sharing this info

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

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

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

  • Gokan Ozcifci edited Revision 3. Comment: Add data

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

  • Richard Mueller edited Revision 5. Comment: Modified title casing

Page 1 of 1 (7 items)