Skip to main content
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
Labels:

Comments

Post a Comment

Popular posts from this blog

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  
Post a Comment
Read more

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

Dear All, Here is the easiest way to make add custom column under your content query web part and then you can format it as you want. Step 1:  Open Sharepoint design Step 2:  Open site for sharepoint parent site collection Step 3:  Locate the following folder Style Library > XLS Style Sheets Step 4:  Open "ItemStyle.xsl"  file Add the custom style sheet as you want <xsl:template name="[Your Style Name]" match="Row[@Style='[Your Style Name]']" mode="itemstyle">                                                   <xsl:param name="CurPos" />                          ...
1 comment
Read more

SharePoint: A Complete Guide to Getting and Setting Fields using C#

Original article https://social.technet.microsoft.com/wiki/contents/articles/21801.sharepoint-a-complete-guide-to-getting-and-setting-fields-using-c.aspx Introduction This article demonstrates how to set and get the various SPField types for a SharePoint list using C#. The examples demonstrated set and get fields from an item that belongs to a custom list. The custom list contains a number of fields, and all the fields are named based on the type of field they are. For example, there is a Text field, which has been named, textfield. This is depicted in the following picture:   Applies To The examples demonstrated below are tested with and apply to the following versions of SharePoint: SharePoint 2010 SharePoint 2013 Get the List, and the first SPListItem This is the basic code for getting an item. If the list has at least one item, the first item is retrieved, otherwise a new item is created. var web = SPContext.Current.Site.RootWeb; var list = web.Lists...
Post a Comment
Read more