Symptom
A Crystal Report aspnet website application has been developed on visual studio 2005 with Microsoft Access as a data-source.
And a relevant setup package has been created using cr_net_2005_mergesmodules_mlb_x86
Merges modules and deployed on IIS 6.0 (workers processes isolation mode)
After applying all the relevant security settings (IIS_WP, ASPNET,
NETWORK SERVICE, IWAN\...., etc) as well as ensuring that the dsn
points to the relevant database, you obtain a "Load report failed"
error when the application runs on any application pools where the
Application pool identity has been set to Network service which is
the default setting.
But the report will load when Application pool identity is set to
Local System
Cause
This is caused by the insufficient right in loading the report from
the Network service account
Resolution
To enable the application to run under the Application pool identity of Network service, you need to configure the web.config of the application by inserting the following
<identity impersonate="false"/> within the tag <system.web>Keywords
Load report failed , 5057569 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed
Product
SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008 ; SAP Crystal Reports, version for Visual Studio .NET 9.1