Network logon prompt when running crystal report

[theoryofben]

Hello All. I have a strange problem that I have never had before. Any help is greatly appreciated.

My app is an intranet app that utilizes a crystal report. The report is located in the same directory as the other site files.

It was working great, but now when we get to the page with the report, it brings up a username/password prompt (the type you get when trying to browse another pc on the domain).

If I put in my info (I'm a domain admin), it works fine. But if I cancel, it bring up the error page saying that access is denied to "C:\\Documents and settings\pcname\ASPNET\Local Settings\Temp\longtempfilename.rpt
I gave full permissions for that folder but it still happens.

Does anyone have any idea what's going on? Is this a configuration problem? This isn't the first app we've deployed on this server using crystal reports.

________________________________________________
_{"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison}

http://www.digital-theory.com

 

[dvannoy]

do the users group have rights as well.. users and aspnet should have rights to that folder on your IIS server.

 

[theoryofben]

Yes, I gave everyone full control just to try and narrow down the problem.

The thing is, my report is located in the project folder under inetpub/

http://wwwroot.

But the problem directory seems to be a temp directory that ASPNET uses on it's own. Is there a way to configure .net to not do that?

The strange thing is, I have another app on the same server that uses a crystal report in the same way and it is still functioning fine.


________________________________________________
_{"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison}

http://www.digital-theory.com

 

[dvannoy]

did you correctly deploy your CR to the IIS server?

 

[theoryofben]

Yes (I think). The report was working fine before the other day. And it will load fine now (if you put in your credentials).

The only thing that changed was that we changed the password of a domain account that was used to link to the server when I set the project up. I'm guessing now that it cached the credential info and that is why it worked fine until we changed the password of the domain account. So, that's why it is now asking for new credentials.

So, maybe the this problem has been here all along. I may just create a deployment package and intall it. Do you think that may solve the problem? I would really like to know what's causing it though.


________________________________________________
_{"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison}

http://www.digital-theory.com

 

[dvannoy]

if your pushing the report and using a dataset, in your connection string you will need to put in the new password and rebuild the project and replace those pages in IIS for the prompt to go away.

 

[theoryofben]

Ok, it's working (for now). I have no idea why it is working. I changed the build action for the rpt to 'None' and built the project. The report would not load like that, so I changed it back to 'Embedded Resource' and now it is not asking for the information.

It was asking for a network logon for the web server not for the sql connection. I'm using the pull method and sending an input parameter. I've specified my sql connection info in code and that has always worked fine.

Even though it is working now, I'm still very uncomfortable with it. I have no idea why the error was happening or how it got fixed. We are starting a beta test on the 15th and this makes me very skittish.

I appreciate your help on this.

________________________________________________
_{"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison}

http://www.digital-theory.com

 

[dvannoy]

well, if that's the case, you have a IIS problem. if you are using a dataset for your CR and on your page load event using a connection string to connect, you should not get prompted for a user name and password. and make sure aspnet and users have access to you app directory.

http://support.businessobjects.com/communityCS/TechnicalPapers/crnet_deployment.pdf

under build action it should embeded