Crystal Report Access Denied

[Chuck Yeager via DotNetMonster.com]

I think I am giong to die, this is driving us nuts.

Here is the error we are getting when trying to use CrystalReportViewer:

OS: XP SP1 and another machine XP SP2 (same errors)
IDE: VS .NET 2003
ERROR MESSAGE
-----------------------------------
Access is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Access is
denied.

Source File: C:\Inetpub\wwwroot\homie\ar15.aspx.cs Line: 30

Stack Trace:
[COMException (0x80004005): Access is denied.
]
CrystalDecisions.ReportAppServer.ClientDoc.ReportC lientDocumentClass.Open
(Object& DocumentPath, Int32 Options) +0
CrystalDecisions.ReportAppServer.ReportClientDocum entWrapper.Open
(Object& DocumentPath, Int32 Options) +72
CrystalDecisions.ReportAppServer.ReportClientDocum entWrapper.EnsureDocumentIsOpened
() +218

[Exception: Load report failed.]
CrystalDecisions.ReportAppServer.ReportClientDocum entWrapper.EnsureDocumentIsOpened
() +269
CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Load(String
filename, OpenReportMethod openMethod, Int16 parentJob) +739
CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Load(String
filename) +52
Homie.mbrCrystalReport.Page_Load(Object sender, EventArgs e) in c:\
Inetpub\wwwroot\homie\ar15.aspx.cs:30
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

------------------------------------
ERROR CODE
------------------------------------
CrystalDecisions.CrystalReports.Engine.ReportDocum ent crReportDocument =
new CrystalDecisions.CrystalReports.Engine.ReportDocum ent();
crReportDocument.Load(@"C:\Inetpub\wwwroot\homie\a r15.rpt");
-------------------------------------

We have tried the temp directory permissions with the ASPNET account option
and it did not work.

What is going on, anyone outhere know?

--
Message posted via http://www.dotnetmonster.com

[Steve C. Orr [MVP, MCSD]]

As a test, you can use impersonation to have ASP.NET run under a different
user account. (Perhaps your user account since you know you have the
necessary permissions.)

For example, you can add a line similar to this to your web.config file:
<identity impersonate="true" userName="domain\MyUserName">
password="password"/>

Here's more info on impersonation:
http://msdn.microsoft.com/library/de...ersonation.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Chuck Yeager via DotNetMonster.com" <fo***@nospam.DotNetMonster.com> wrote
in message news:e1******************************@DotNetMonste r.com...

I think I am giong to die, this is driving us nuts.

Here is the error we are getting when trying to use CrystalReportViewer:

OS: XP SP1 and another machine XP SP2 (same errors)
IDE: VS .NET 2003
ERROR MESSAGE
-----------------------------------
Access is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Access is
denied.

Source File: C:\Inetpub\wwwroot\homie\ar15.aspx.cs Line: 30

Stack Trace:
[COMException (0x80004005): Access is denied.
]

CrystalDecisions.ReportAppServer.ClientDoc.ReportC lientDocumentClass.Open
(Object& DocumentPath, Int32 Options) +0
CrystalDecisions.ReportAppServer.ReportClientDocum entWrapper.Open
(Object& DocumentPath, Int32 Options) +72

CrystalDecisions.ReportAppServer.ReportClientDocum entWrapper.EnsureDocumentIsOpened
() +218

[Exception: Load report failed.]

CrystalDecisions.ReportAppServer.ReportClientDocum entWrapper.EnsureDocumentIsOpened
() +269
CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Load(String
filename, OpenReportMethod openMethod, Int16 parentJob) +739
CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Load(String
filename) +52
Homie.mbrCrystalReport.Page_Load(Object sender, EventArgs e) in c:\
Inetpub\wwwroot\homie\ar15.aspx.cs:30
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

------------------------------------
ERROR CODE
------------------------------------
CrystalDecisions.CrystalReports.Engine.ReportDocum ent crReportDocument =
new CrystalDecisions.CrystalReports.Engine.ReportDocum ent();
crReportDocument.Load(@"C:\Inetpub\wwwroot\homie\a r15.rpt");
-------------------------------------

We have tried the temp directory permissions with the ASPNET account
option
and it did not work.

What is going on, anyone outhere know?

--
Message posted via http://www.dotnetmonster.com

[Elton Wang]

Hi Chuck,

When a CR is being created in ASP.NET, the .NET will
create a report file in a temp folder, e.g. C:\Documents
and Settings\UserName\ASPNET\Local Settings\Temp. You can
try to give ASPNET permission for this folder.

HTH

Elton Wang
el********@hotmail.com

-----Original Message-----
I think I am giong to die, this is driving us nuts.

Here is the error we are getting when trying to use CrystalReportViewer:
OS: XP SP1 and another machine XP SP2 (same errors)
IDE: VS .NET 2003
ERROR MESSAGE
-----------------------------------
Access is denied.
Description: An unhandled exception occurred during the execution of thecurrent web request. Please review the stack trace for more informationabout the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Access isdenied.

Source File: C:\Inetpub\wwwroot\homie\ar15.aspx.cs Line: 30
Stack Trace:
[COMException (0x80004005): Access is denied.
]
CrystalDecisions.ReportAppServer.ClientDoc.ReportC lientDocu
mentClass.Open(Object& DocumentPath, Int32 Options) +0
CrystalDecisions.ReportAppServer.ReportClientDocum entWrappe
r.Open(Object& DocumentPath, Int32 Options) +72
CrystalDecisions.ReportAppServer.ReportClientDocum entWrappe
r.EnsureDocumentIsOpened() +218

[Exception: Load report failed.]
CrystalDecisions.ReportAppServer.ReportClientDocum entWrappe
r.EnsureDocumentIsOpened() +269
CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Load
(Stringfilename, OpenReportMethod openMethod, Int16 parentJob) +739 CrystalDecisions.CrystalReports.Engine.ReportDocum ent.Load
(Stringfilename) +52
Homie.mbrCrystalReport.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\homie\ar15.aspx.cs:30
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

------------------------------------
ERROR CODE
------------------------------------
CrystalDecisions.CrystalReports.Engine.ReportDocu ment crReportDocument =new CrystalDecisions.CrystalReports.Engine.ReportDocum ent (); crReportDocument.Load (@"C:\Inetpub\wwwroot\homie\ar15.rpt");-------------------------------------

We have tried the temp directory permissions with the ASPNET account optionand it did not work.

What is going on, anyone outhere know?

--
Message posted via http://www.dotnetmonster.com
.

[Chuck Yeager via DotNetMonster.com]

Thanks for your feedback gentlemen,

Steve,

I have tried Steve's option and the error is gone, but I do not want to
hard code the username and password.
Elton,

I have tried that and access denied still occurs.
I will probably stumble accross the answer while sitting on the pot tonight
just before I go to bed. :)

But, just in case any other ideas would be greatly appreciated

--
Message posted via http://www.dotnetmonster.com

[Steve C. Orr [MVP, MCSD]]

Putting values in a web.config is not the same as hardcoding.
Web.Config values can be easily changed at any time without recompiling.

However, if you're determined to find another solution I'd suggest you start
by searching the Crystal Reports knowledge base:
http://support.businessobjects.com/s...exq3=&indexq4=

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"Chuck Yeager via DotNetMonster.com" <fo***@DotNetMonster.com> wrote in
message news:26******************************@DotNetMonste r.com...

Thanks for your feedback gentlemen,

Steve,

I have tried Steve's option and the error is gone, but I do not want to
hard code the username and password.
Elton,

I have tried that and access denied still occurs.
I will probably stumble accross the answer while sitting on the pot
tonight
just before I go to bed. :)

But, just in case any other ideas would be greatly appreciated

--
Message posted via http://www.dotnetmonster.com

[Chuck Yeager via DotNetMonster.com]

Thanks Steve!

I will look at that

--
Message posted via http://www.dotnetmonster.com

[Chuck Yeager via DotNetMonster.com]

I put in the web config the following and it works like a charm!

<authentication mode="Windows" />

<identity impersonate="true" userName="domainname\username"
password="mypassword" />

--
Message posted via http://www.dotnetmonster.com