Solved

Access Denied by Bussiness Data Conectivity in Sharepoint Designer 2010

Posted on 2010-11-08
4
640 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Suggested Courses

617 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