Home > SharePoint 2010, SharePoint Administration > SharePoint 2010: Access Denied by Business Data Connectivity within SharePoint 2010 Designer

SharePoint 2010: Access Denied by Business Data Connectivity within SharePoint 2010 Designer

If you are attempting to add a connection to an external data source within SharePoint 2010 Designer and you recieve the following error:

“Access denied by Business Data Connectivity”

Make sure you grant the proper permissions to the Business Data Connectivity Service Metadata Store within Central Administration.

1.  Browse to your Central Administration Site
2.  Browse to Application Management – Manage Service Application – Business Data Connectivity
3.  Within the Business Data Connectivity Service Application, click the “Set Metadata Store Permissions” icon in the ribbon
4.  Grant the proper permissions to those needed to establish DBC external connections (Edit, Execute and Set Permissions).

After granting permissions, attempt to establish your connection within SharePoint 2010 Designer again.  This time you should be able to connect and see your data source.

Hopefully this helps others.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: