You are visiting the High Monkey blog archive. Posts prior to 2016 may not meet accessibility standards. Please visit our current blog area at https://www.highmonkey.com/blog to view accessibility compliant blog posts published since January 1, 2016.

Error: “Access denied by Business Data Connectivity”

Written By: High Monkey
Posted: 1/9/2014

(From the mind of Peter Serzo, Previously VP of Consulting Services at High Monkey)

I configured an ECT following a great post by Fabian Williams:
http://www.sharepointfabian.com/2010/04/16/how-to-create-configure-consume-sharepoint-2010-secure-store-in-business-connectivity-services/

The unique goal of this ECT connection is to be of use by a process (SharePoint Hosted App) - not by a person.  So I need to apply the concept of least priviledge.

I began configuring an external content type (ECT) for a SP2013 instance.  I created a domain account for BCS Access to my SQL DB tables (spbcs_sqlaccess), gave it proper priviledges to the external data, set permissions on the account in Central Admin.  Finally, configuring Secure Store with the Application ID with a Target Application Type of Individual.

At the point in SPD SP2013 when you create the connection to SQL which will then pull back the tables from SQL, I kept getting  

Error: “Access denied by Business Data Connectivity”

There are a lot results in search for this - but I only found one that helped me really understand what was happening.  

Here is the answer: http://stackoverflow.com/questions/11535488/access-denied-by-business-data-connectivity-error

I was logged onto my desktop as pserzo, then I logged into SPD as pserzo (Site Collection Owner), and tried creating the ECT.  NO!

You cannot do that - Pserzo does not have priviledges to use BCS  - Pserzo need access via the Metadata Store Permissions.  Once I added myself here, everything worked as it should.

 
 

Chad's Bio Coming Soon!

More About Virgil

Virgil Carroll is the owner and president of High Monkey – based in Minneapolis Minnesota. Virgil also wears the multiple ‘hats’ of Principle Human Solutions Architect and SharePoint Architect.

Virgil is one of those rare individuals who can dive deep into technical topics while speaking clearly to the business owners of a project and never forgetting that the end user experience has the highest priority. He calls it using both sides of his brain. Virgil is passionate about leveraging technologies ‘out of the box’ as much as possible with a focus on the strategic use of content to create websites that deliver the right content to the right audience on the right device at the right time. Virgil brings high energy, an ironic wit, and a sense of grounded perspective whenever he speaks to an audience. Virgil regularly speaks at conferences and user groups throughout the United States and occasionally in Europe.

Posted: 1/9/2014 12:00:00 AM by Brian Haukos | with 0 comments