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 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 .
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.
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.
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.
kiran001
2 Posts
problems in publishing Crystal reports
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
jeff@zina.co...
3379 Posts
MVP
Moderator
Re: problems in publishing Crystal reports
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.
Jeff
kiran001
2 Posts
Re: problems in publishing Crystal reports
Sep 13, 2007 06:50 AM|LINK
Hi Jeff,
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 .
Thanking you
qbernard
5019 Posts
MVP
Moderator
Re: problems in publishing Crystal reports
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.
See
Internet Explorer May Prompt You for a Password
http://support.microsoft.com/Default.aspx?id=258063
To look at what request was having access issue, look at the iis log file for request with 401.x status code.
Bernard Cheah
nps
3 Posts
Re: problems in publishing Crystal reports
Jun 13, 2008 06:50 AM|LINK
Hi Experts,
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
Software Engineer
Domimutai
1 Post
Re: problems in publishing Crystal reports
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.
qbernard
5019 Posts
MVP
Moderator
Re: problems in publishing Crystal reports
Sep 09, 2008 09:02 AM|LINK
what your error code ? anything in event log ? have you read the article ?
Bernard Cheah
nps
3 Posts
Re: problems in publishing Crystal reports
Sep 14, 2008 07:36 AM|LINK
hi,
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.
Software Engineer
b.billygraha...
1 Post
Re: problems in publishing Crystal reports
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?
Regards,
Bright Billy Graham
Chennai.
tomkmvp
7657 Posts
MVP
Moderator
Re: problems in publishing Crystal reports
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 http://forums.asp.net/ ...
http://mvp.support.microsoft.com/