SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created an external content type which displays the data from the SQL table. And the external list's data I am displaying the web part. The site is to be made available to the anonymous users. To make the data available to anonymous users, I have followed this steps. But I am getting same error.

Is there any other method to make external list available to anonymous users in SharePoint 2013?

share|improve this question

The external content types is very prone for security issues.

Do you have pass though authentication enabled on the connection to your Database? This means that you have to give individual users access. Which will not work since anonymous users are not actually logged in.

An other option is to use the Secure Store and 'impersonate' the user. This means that the anonymous user uses an other username/password to access the database.

There is a lot of information on the internet

Tip: I also noticed that (security) changes in BCS sometimes take a few seconds to be applied. Make sure you wait 10-20 seconds before doing a page refresh after configuring (security) changes.

share|improve this answer

Just to anybody with similar problem but in different scenario. In our case BDC was called from separated service. So if you are calling and trying to access external CT from client code, make sure that account under which such application/service/site is running is also set as user in "Set Object permissions".

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.