Dear All

Following are the steps for the

After this setup if you got the error for the
"Access denied by Business Data Connectivity error for anonymous users when accesing external list" 


You need to follow the following steps 
1.png

 This is because the user doesn't have the permission to the external content type.
How to resolve:
  1. Open Central Administration.
  2. Click on Manage service applications which is available in the Service Applications section.
  3. Click on Business Conectivity service application.
  4. Select the external content type, click on Set Permissions in the ECB menu.
2.png
  1. Add the user and then click on Add.
3.png
  1. Give the permissions for the user and click on Ok.
4.png
  1. Now navigate to the external list you will be able to see the data in the list.
5.png

After that if you face a problem with the “Login failed for user "NT AUTHORITY\ANONYMOUS LOGON" while browsing to external list.”

To resolve it following script need be write 
$bdc = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}
$bdc.RevertToSelfAllowed
$bdc.RevertToSelfAllowed = $true
$bdc.Update()

and update the connection database to BDC in external content via sharepoint 
Below Connection properties -> Select Client -> Below Secure Store Application ID -> Select BDC Identity.

Below Connection properties -> Select Default-> Below Secure Store Application ID -> Select BDC Identity.


I hope it resolve your issue completely

Regards
3art Technology Experts
http://www.3art.tech

Comments

Popular posts from this blog

Content Query Webpart Template In SharePoint 2013 and add new column in it

Open and Close SharePoint Dialog Box or dlg and Refresh Parent Page

Updatepanel or Enable Ajax in SharePoint webpart