Solved

Access Denied by Bussiness Data Conectivity in Sharepoint Designer 2010

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
This collection of functions covers all the normal rounding methods of just about any numeric value.
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 …

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now