SSRS and ASP.Net and Windows Integrated authentication failure in Internet Explorer
I have a very confusing problem that I'm going to attempt to relay concisely: I have a LAN on which I'm running an Intranet web site built in ASP.Net 2.0 and using SSRS / Sql Server 2005 on the same server. The name of the box is "warehouse" or "warehouse.mydomain.us." When I ping "warehouse," I get a response from 137.86.166.8, as I should. Likewise, I get a response from 137.86.166.8 when I ping "warehouse.mydomain.us." If I do a "ping -a" on 137.86.166.8, it correctly resolves to "warehouse.mydomain.us." Basedon the facts presented in thisparagraph, I believe that my DNS is working as expected. Using IE (6.0.2900.2180.xpsp_sp2_gdr.050301-1519) with "low" security settings, I navigate to http://warehouse.mydomain.us/lex/ (Lex is the name of the app) and it authenticates me to the index page (which calls the SSRS web service to get and display a list of available reports), except that I get the login prompt three times. If I hit F5 (refresh), I get three more login prompts and then I get a 401.1 error. From this point, no matter what I do, I can not see the index page again without closing and restarting IE. I know that IE only passes credentials to certain sites, so I add my domain (http://warehouse.mydomain.us/) to the Local Intranet list (Tools->Internet Options->Security->Local Intranet->Advanced) and then I can refresh and see my index page once, but I still get 3 login attempts and then the same thing happens -- I refresh and go through 3 logins and then get a 401.1. If I now change my address bar to read http://137.86.166.8/lex, I get a single login and it works like a champ. This makes me think that there's a DNS problem, so I open up Mozilla Firefox and wouldn't you know it -- Firefox works like a champ all around -- one single sign-in, it keep credentials between Lex and SSRS, and it appears to use the DNS correctly. However, I can't use Firefox because I can't get any of the SSRS reports to look like they're supposed to in Mozilla-based browsers. Argh. I have set my IE securtiy settings to "Low." I have added the primary domain to the Local Intranet list and also to the Trusted Sites list (but you can't do both at the same time). I have even added the internal IP to my "hosts" file. Does anyone know anything that might be a help to me in getting this figured out? Other notes of interest: My machine is an XP machine, but is not on the domain, but I do have a valid domain login that I use and it works in Firefox without problem.
June 1st, 2006 10:43pm

did you get this issue resolved. I am just curious to know. You can reply to this post or directly email me: tafs7 at yahoo.Regards,Thiago Silva
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2007 9:08pm

i am having the same problem!were you able to fix this?
July 31st, 2008 11:38pm

I've been experiencing the same problem as well, with a generic SSRS install, with "Reports" as the application running Reporting Services. I've found one workaround, and that is to change the directory security over to "Basic" then both IE and Firefox both pop up a login box and work file. But, we use integrated security as a rule at our company (single sign-on and such) so using integrated security is where we want to be. Have any of you all found another solution to the issue?
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2009 9:35pm

As a follow up, if I set Firefox to perform NTLM authentication (i.e. Integrated Authentication) with the server it can no longer access the Reporting Services UI. So it appears to be an NTLM authentication & SSRS issue. But I think it worked at one time, but I can't be sure.
May 12th, 2009 9:40pm

I set 'Enable Integrated Windows Authentication' in IE8 Advanced Setting to OFF. It sounds crazy but it solve this problem for me. MarkMarkU
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2009 5:09pm

This worked for me oddly enough. I hate IE8.The Computer Shogun
January 22nd, 2011 7:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics