Sql Server Reporting Services 2008 R2 Integrated with Sharepoint 2010 RRS feed

  • Question

  • I am trying to Integrate Sql server Reporting Services 2008 R2 with SharePoint Server 2010.

    When I deploy the reports from BIDS (ssrs), I can find the Reports in the Report Server, and when I am trying to open the same in SharePoint site its showing an "Trusted account mode" error.

    what exactly means the "Trusted account mode" (which we set up in SharePoint Ccentral Administration)

    The following error is the one which I am facing in share Point Site when  trying to open the report.

    An error has occurred during report processing. (rsProcessingAborted)

    Cannot impersonate user for data source 'Wells_Online'. (rsErrorImpersonatingUser)

    This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)


    Any Help Would Greatly Appreciated.



    • Moved by Emir Liu Thursday, August 18, 2011 1:32 AM SharePoint 2010 question (From:SharePoint - Business Intelligence (pre-SharePoint 2010))
    Wednesday, August 17, 2011 7:16 PM


All replies