Solved

Access Denied by Bussiness Data Conectivity in Sharepoint Designer 2010

Posted on 2010-11-08
4
627 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

820 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