IIS 5 & IIS 6
problems in publishing Crystal reports
Last post Apr 19, 2011 12:17 AM by itmanager
Sep 12, 2007 09:27 AM|LINK
Hi all, I am working on ASP.net 2.0 and SQL server 2005 . I am having problem in publishing my crystal report . I have published the website in IIS , all my webforms works fine only problem is with crystal report .Whenever i try to open Crystal report ,
it gives Login box requesting for login ID and password ,if i continously click on cancel in login box ,it then succesfully displays data . So i think there is no problem in retrieving data from database into the Crystal report , but can anyone tell me why
am i getting that login box .
Thanks in advance
Sep 12, 2007 03:40 PM|LINK
Try adding the domain to the Intranet zone is IE's security tab, that way IE will pass credentials.
Sep 13, 2007 06:50 AM|LINK
Thanks a lot for replying ,it worked . I am not facing this problem in my comp it doesn't give me that login box ,but when i try accessing it through other comp then it gives me the login box ,this time i have to click on cancel twice and it displays the
data very well .Before changing those setting of IE ,it was giving the login box and i had to click cancel 22 times . Now it has reduced to 2 clicks . Can you please tell me how should i avoid this login box to pop up in others comp .
Sep 15, 2007 05:01 AM|LINK
This will depends on what authentication is configured and whether the current user has permissions to access the resource. The trick posted by Jeff was to instruct IE to include the url in the trusted zone so that IE is able to auto login for domain user.
Internet Explorer May Prompt You for a Password
To look at what request was having access issue, look at the iis log file for request with 401.x status code.
Jun 13, 2008 06:50 AM|LINK
I am also facing the same problem.
I have added to the trusted site. Again I am facing the same problem.
Any Suggestions. Thanks in Advance
Sep 09, 2008 08:57 AM|LINK
Also facing the Same problem.The login box just wont go away. All the other aspx web forms work fine. There is no user name and pwd in the access database i am using. I have tried all the above suggestions but i am still having this login dialog box that
wont let my users view reports.
Please help. Urgent.
Sep 09, 2008 09:02 AM|LINK
what your error code ? anything in event log ? have you read the article ?
Sep 14, 2008 07:36 AM|LINK
there will be folder aspclient in www root which have the supporting files for the crystal reports(js, images). set aspnet rights to that folder and check it.
it will solve your problem.
Jan 22, 2009 09:49 AM|LINK
I added this line of code in the web.config
<identity impersonate="true" userName="Domain\MyUsername" password="MyPassword"/>
But report load failed.
I m working with VS 2008 and C#. That server hasn't the crystal report.
Anybody help me?
Bright Billy Graham
Jan 22, 2009 06:29 PM|LINK
You'll get a better response by either following-up with Crystal Reports or by posting over at