Tuesday, October 2, 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 …”.

2 comments:

  1. Every person, every organization, and every business gets stuck. For successful people and businesses, it can be very hard to recognize that they are stuck and even harder to do what is necessary to break free of old ideas and habits to get back on the growth path. ​start the f up

    ReplyDelete
  2. These telephone numbers work parallel with existing landline or versatile numbers. In this manner, there is no requirement for putting resources into new hardware, lines, or additional telephones for the numbers.0800 call forwarding

    ReplyDelete