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.
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.