Solved

Access Denied by Bussiness Data Conectivity in Sharepoint Designer 2010

Posted on 2010-11-08
4
617 Views
Last Modified: 2012-05-10
Hi ,

I am trying to create a new external content type in sharepoint desiner. I am trying to pull information from SQL table. I also created one Secure store service application with my credentials.

During the process of creation new External content type in sharepoint Desiner, I got the error message as "Access Denied bu Bussiness Data Connectivity"
BDC-ERROR.JPG
0
Comment
Question by:marneni9999
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
raybies earned 500 total points
ID: 34549648
Add your account in to the Metadata Store Permissions table.

CA > Application Management > Manage service applications > BDC App > Set Metadata Store Permissions (check all of them)
0
 
LVL 16

Assisted Solution

by:raybies
raybies earned 500 total points
ID: 34549684
If that didn't work try adding your account to BDC App permissions table...

CA > Application Management > Manage service applications > BDC App (Click to highlight) then from the Ribbon select Permissions.
0
 
LVL 17

Expert Comment

by:GreatGerm
ID: 36128954
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sharepoint 2013 error 4 54
SharePoint display modal blank 2 58
Sharepoint 2010 Audit Logs 11 102
VBA name newly created sheet 4 24
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question