Monday 1 October 2012

How To Fix “Access denied by business data connectivity” in SharePoint 2010

You get “Access denied by business data connectivity” error when working with BCS. Take following steps to resolve this issue.
1. Go to central admin site. Click “Application Management”.



Figure 1: Manage service applications
2. Click “Manage service applications” under “Service Applications”.
3. Locate “Business Data Connectivity Service”


Figure 2: BCS service

4. Select the application that has problem and then Click “Set Object Permission” button in the ribbon.




Figure 3: Set Object Permission

5. Assign permissions to the user.





Figure 4: Assign permissions

Add user first and then assign permissions to them. You can select edit, Execute, Selectable In Clients, Set Permissions from the list. Check “Propagate permissions to all methods of this external content type …”.

No comments:

Post a Comment