Monday, December 27, 2010

Access denied by Business Data Connectivity

When I tried to fetch SQL Data using BDC using diffrent user then Administrator below error I found. Open Central Administrator Site and then open Application Management Tab's Manage Service Appplications link as below.
Select Business Data Connectivity Service as below
Then after checked your external content type's set object permissions as below.
Add your Users and set permissions as below

Now Open your External List & see all SQL Data.
Happy Coding !!!

No comments:

Post a Comment