SharePoint 2010: Business Connectivity Services

This article explains step-by-step how to make an external content type using Microsoft Business Connectivity Services (BCS).

Read More >>

SharePoint Business Connectivity Services - Part 4

Modifying External Content Type

You can modify external content type if you want to make changes. For example, in the above figure you may have noticed that you only see three records where the country is US. What if you want to show all records? You can remove the filter from the content type.

SharePoint Business Connectivity Services - Part 3

BCS Login failed for user NT Authority

If you have created an external content type and are trying to access it in a list and get Access Denied that is because you have not given permissions to the logged in user to use that external content type. You can easily give permissions to that user or to all users in your site by going to central administration site and configuring business connectivity service.

SharePoint Business Connectivity Services - Part 2

1. Click Next.

2. Click Add Filter Parameters button.  In the Properties pane, select Country in the Data Source Element drop down. Click Click to Add link in the Filter field.

SharePoint 2013 Business Connectivity Services Access Denied Error

In SharePoint 2013, If you have setup Business Connectivity Services, or BCS for short, and now you are trying to access an external content type in a list but you get “Access denied by Business Data Connectivity”, here is you will solve it.

 

 This error occurs because the logged in user does not have permissions on the external content type that you had created. To resolve the issue go to central administration site and give permissions to specific users on the external content type.

1.       Open SharePoint Central Admin site.

2.       Click Application Management.

3.       In Service Applications section, click Manage service applications.

4.       Click Business Data Connectivity Service.

5.       You will see your external content type listed on this page. Select it (by checking the box) and click Set Object Permissions button in the ribbon.

 6.       This will open a dialog box. Enter username that you want to give permission to in the box and click Add. Select the added user in the box below and select permissions for that user by checking the boxes against the listed permissions. Depending on the type of user, you can select which permissions to give. For example, giving them Execute permission will let them see the results. If the user is admin type, then give them all the permissions. Lastly, check the box at the bottom to “propagate” permissions to all methods of the external content type. Click OK to save the settings.

 

 

 Also, if you want to give access to all users in the organization, add NT Authority\Authenticated Users in the box at the top and click Add and then assign desired permissions as described above. When you add authenticated users, you see All Users (windows) listed as one of the users.

 

 

Access denied by business data connectivity

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 …”.