[RESOLVED] Load Report Failed

[danasegarane]

Hi all,
I have developed reports using crystal report which work well in Win XP(Dev & Server) but when we started to deploy it in Windows 2003 server , we are getting the Result as "Load report failed ".

Have any one experienced this one ?


Thanks
Dana

[gep13]

Hey,

Are there any log files that you can look at? It is likely that you will find more helpful information in there.

Gary

[danasegarane]

I am writing it to EventViewer and gettting the result as LoadReport Failed.

One Impartant thing I forgot to mention is if I don't use the

<identity impersonate="true" >

Its working Well. If add this I get this Error only in Windows 2003 Server. Works well in XP (Local/Server)

[gep13]

Hey,

This immediately points at a difference in the way the servers are configured, i.e. differences in permissions.

Are you in charge of configuring permissions on the server?

Gary

[danasegarane]

Yes . Currently for this we have got special permission

[gep13]

Hey,

So I take it that you want the report to run using:

<identity impersonate="true" >

In which case, you need to get someone to give each user the necessary permission to access the datasource that the reports are hitting.

Gary

[danasegarane]

Now I will give the username and password there itself.

<identity impersonate="true" userName="DomainName\UserName" password="Password"/>

[gep13]

Hey,

When you use:

<identity impersonate="true" >

You are basically telling ASP.Net to use the Identity of the current user to run the application. As a result, when you query databases, load reports etc, you will be doing so as the current user. As a result, the permissions for that user might not be sufficient to execute the report.

When you take out the above from the web.config file, you are running the application as the ASP.Net Identity, configured in IIS, which obviously does have the necessary permissions, as the report loads.

Gary

[danasegarane]

Hey,

When you use:

<identity impersonate="true" >

You are basically telling ASP.Net to use the Identity of the current user to run the application. As a result, when you query databases, load reports etc, you will be doing so as the current user. As a result, the permissions for that user might not be sufficient to execute the report.

When you take out the above from the web.config file, you are running the application as the ASP.Net Identity, configured in IIS, which obviously does have the necessary permissions, as the report loads.

Gary

Previously it was running under Asp.Net identity and we introduced Excel Automation to generate the reports. As the Asp.net identity won't have rights to access the server application , we have to opt for the impersonate

[gep13]

Hey,

Okay, so can you try altering the user's permissions, i.e. increasing them, to allow them to access the reports?

Gary

[danasegarane]

yes I can

[danasegarane]

Never Mind . I figured out My self. The w3pwp.exe was running under "NETWORK SERVICE" account. During the Crystal Report Load method , it create a tempory file in Windows temp directory. The "NETWORK SERVICE " doesn't had the access to that folder. I gave the read/write permission , which solved the issue

[gep13]

Hey,

Glad to here that you got it working Dana.

Gary

[danasegarane]

Thanks Gary.

After Lot of search only I was able to rectify that one. I have one doubt. Does granting write permission to windows folder will cause any damage ?

[gep13]

Hey,

I wouldn't give write permissions to the whole windows folder, just the the relevant folder.

Gary

[danasegarane]

Now I am granting to Temp folder only. Will it cause any security flaw ?

[gep13]

Hey,

You are only granting write access to one folder, so you should be fine.

Gary

[danasegarane]

Ok..

[mendhak]

The NETWORK SERVICE account is pretty low privilege anyways. That's why it's given permissions on temporary folders in a few places on your machine so that it's out of way's harm/harm's way.

[danasegarane]

Thanks for the advice mendhak