1200777 - Load report failed

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