Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

BCS Error – Access denied by Business Data Connectivity

Posted by Paul on January 23, 2016


You will get the following error while first time configuring BCS.

· Access denied by business data connectivity.

image

Solution

Following would be the solution.

Open Central Administration > Manage Service applications > Click Business Data Connectivity Service.

image

In the appearing page click on the Set Metadata Store Permissions ribbon item.

image

You will get the following page. Here do the following:

· Enter Everyone and click Add button

· Check all the permissions listed below

· Check the Propagate Permissions too

Click OK button.
image

Now retry your BCS List in SharePoint.

Summary

In this post we have explored a common error while configuring BCS & steps to resolve it.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s