locked
CRM 2011 - User Was not found RRS feed

  • Question

  • While trying to resolve a issue with Reporting services I accidently  Deleted Encrypted content from "Reporting Services Configuration Manager".  I was able to recover from it for non CRM reports.  However, the CRM reports are throwing following error...

    • An error occurred during client rendering.
      • An error has occurred during report processing.
        • Query execution failed for dataset 'DSMain'.
          • Microsoft.Crm.CrmException:
            An unexpected error occurred.
            System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault,
            Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral,
            PublicKeyToken=31bf3856ad364e35]]: User Was Not Found
            <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance"
            xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
            <ErrorCode>-2147220969</ErrorCode> <ErrorDetails
            xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic"
            /> <Message>User Was Not Found</Message>
            <Timestamp>2012-10-23T19:38:44.7764669Z</Timestamp> <InnerFault
            i:nil="true" /> <TraceText i:nil="true" />
            </OrganizationServiceFault>
            • An unexpected error occurred.
              • User Was Not Found

    I think it has to do with database connection issue.

    I'm using domain account for Report Server Service Account.  I haven't checked the check box for Execution Account.  CRM is on one server and RSS and database on another.

    MSCRM_DataSource:

       Hide in list view is checked

       Enable this data source is checked

       Data source type: Microsoft Dynamics CRM SQL

       Connection String: [blank]

    Connect Using:

       Windows integrated security (selected)

    I'm not sure if this is the correct set up.  This is the first time I'm workign on CRM / RSS.

    any guidance would be appreciated.

    Tuesday, October 23, 2012 7:48 PM