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