locked
Error Accessing External List data as 'Anonymous User' RRS feed

  • Question

  • I am using Business Connectivity Service to fetching data from External SQL server , for that I have created External Content Type by using "Impersonates Custom Identity " data connection. Created external list using that External Content Type & use that list in Data View Web part to show the data.

    When I access that Data View Web part with “System Account’ that is working fine, but when I access that data view web part as 'Anonymous User' I am getting below Error:

    Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer.
    If the problem persists, contact your Web server administrator.

    To troubleshoot that issue I have already done below activities but didn’t get any success.

    • Given ‘NT Authority\Anonymous Logon’ Group to Execute rights on External Content Type / External System / BDC Model

    • Given Full trust to the application.

     


    VivekShukla

    Saturday, September 8, 2012 1:31 PM

Answers

  • Hi Vivek,

    You can't use following identity type for external data source connection in anonymous configuration. Pleas use BDC Identity .

    User’s Identity, Impersonate Windows Identity, or Impersonate Custom Identity

    Hope it will work.

    Refer this blog: Its very helpful

    http://www.dontpapanic.com/blog/?p=131

    Regards

    Gyan Shukla


    GYAN SHUKLA

    • Proposed as answer by Gyan Shukla Saturday, September 8, 2012 7:25 PM
    • Marked as answer by AliceJohn Saturday, September 8, 2012 8:12 PM
    Saturday, September 8, 2012 7:19 PM

All replies