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.
            Microsoft.Xrm.Sdk, Version=, Culture=neutral,
            PublicKeyToken=31bf3856ad364e35]]: User Was Not Found
            <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance"
            <ErrorCode>-2147220969</ErrorCode> <ErrorDetails
            /> <Message>User Was Not Found</Message>
            <Timestamp>2012-10-23T19:38:44.7764669Z</Timestamp> <InnerFault
            i:nil="true" /> <TraceText i:nil="true" />
            • 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.


       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