|
|
You're in the
sql server reporting services
group:No authentication prompt when running report
sql server reporting services:
can log in successfully. When I attempt to run a report, I should be prompted again. For some reason, I am not getting prompted when running the report so I am given an Action canceled, web page could not be found error. The strange part is that if I log into the Reports site on the server hosting reports, I am prompted this second time and can run the report successfully. Does anyone know of any authentication settings that might be causing this
Hello,
Basd on my scope, I think it is normal becasue sessionstate/cookies are enabled for report manager. However, if you use Windows authentication, you shall not be prompted to log on in the first place. You may want to check the following IE settings: Tools->Internet Options->Security->Custom level Under User authentication, check if "Prompt for user name and password" is selected. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- [quoted text, click to view] >Thread-Topic: No authentication prompt when running report
>thread-index: AcY/thPOAKype6FWTeSkYUFrw7ffqQ== >X-WBNR-Posting-Host: 68.163.226.168 >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >Subject: No authentication prompt when running report >Date: Sat, 4 Mar 2006 10:04:27 -0800 >Lines: 8 >Message-ID: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> >MIME-Version: 1.0 >Content-Type: text/plain; > charset="Utf-8" >Content-Transfer-Encoding: 7bit >X-Newsreader: Microsoft CDO for Windows 2000 >Content-Class: urn:content-classes:message >Importance: normal >Priority: normal >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >Newsgroups: microsoft.public.sqlserver.reportingsvcs >Path: TK2MSFTNGXA03.phx.gbl >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69826 >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >Strange problem: When I go to the reports site, I get prompted to login. I >can log in successfully. When I attempt to run a report, I should be >prompted again. For some reason, I am not getting prompted when running the >report so I am given an Action canceled, web page could not be found error. >The strange part is that if I log into the Reports site on the server hosting >reports, I am prompted this second time and can run the report successfully. >Does anyone know of any authentication settings that might be causing this >behavior? >
Peter, thanks for the reply. Unfortunately, this is not the answer. This
site is set up in Trusted Zones and it is set to prompt for un/pw. On the server, both the Reports and Reports Server vdirs are set to Basic Auth. The domain is not configured to work with windows auth so I should be prompted twice. This is the case on a second server I have SQL Reports configured on and it works correctly. Any further ideas? [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello, > > Basd on my scope, I think it is normal becasue sessionstate/cookies are > enabled for report manager. > > However, if you use Windows authentication, you shall not be prompted to > log on in the first place. You may want to check the following IE settings: > > Tools->Internet Options->Security->Custom level > Under User authentication, check if "Prompt for user name and password" is > selected. > > Best Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > -------------------- > >Thread-Topic: No authentication prompt when running report > >thread-index: AcY/thPOAKype6FWTeSkYUFrw7ffqQ== > >X-WBNR-Posting-Host: 68.163.226.168 > >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >Subject: No authentication prompt when running report > >Date: Sat, 4 Mar 2006 10:04:27 -0800 > >Lines: 8 > >Message-ID: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > >MIME-Version: 1.0 > >Content-Type: text/plain; > > charset="Utf-8" > >Content-Transfer-Encoding: 7bit > >X-Newsreader: Microsoft CDO for Windows 2000 > >Content-Class: urn:content-classes:message > >Importance: normal > >Priority: normal > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > >Newsgroups: microsoft.public.sqlserver.reportingsvcs > >Path: TK2MSFTNGXA03.phx.gbl > >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69826 > >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > > > >Strange problem: When I go to the reports site, I get prompted to login. > I > >can log in successfully. When I attempt to run a report, I should be > >prompted again. For some reason, I am not getting prompted when running > the > >report so I am given an Action canceled, web page could not be found > error. > >The strange part is that if I log into the Reports site on the server > hosting > >reports, I am prompted this second time and can run the report > successfully. > >Does anyone know of any authentication settings that might be causing this > >behavior? > > >
Hello,
This could occur if the user is not in content manager role. You may try to log on as a user with admin role on SRS to test. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- [quoted text, click to view] >Thread-Topic: No authentication prompt when running report
>thread-index: AcZBJ94Y028mCY/6RlaHqrRQ/N2R6w== >X-WBNR-Posting-Host: 149.24.175.16 >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> >Subject: RE: No authentication prompt when running report >Date: Mon, 6 Mar 2006 06:11:31 -0800 >Lines: 76 >Message-ID: <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> >MIME-Version: 1.0 >Content-Type: text/plain; > charset="Utf-8" >Content-Transfer-Encoding: 7bit >X-Newsreader: Microsoft CDO for Windows 2000 >Content-Class: urn:content-classes:message >Importance: normal >Priority: normal >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >Newsgroups: microsoft.public.sqlserver.reportingsvcs >Path: TK2MSFTNGXA03.phx.gbl >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69866 >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >Peter, thanks for the reply. Unfortunately, this is not the answer. This >site is set up in Trusted Zones and it is set to prompt for un/pw. On the >server, both the Reports and Reports Server vdirs are set to Basic Auth. The >domain is not configured to work with windows auth so I should be prompted >twice. This is the case on a second server I have SQL Reports configured on >and it works correctly. Any further ideas? > >"Peter Yang [MSFT]" wrote: > >> Hello, >> >> Basd on my scope, I think it is normal becasue sessionstate/cookies are >> enabled for report manager. >> >> However, if you use Windows authentication, you shall not be prompted to >> log on in the first place. You may want to check the following IE settings: >> >> Tools->Internet Options->Security->Custom level >> Under User authentication, check if "Prompt for user name and password" is >> selected. >> >> Best Regards, >> >> Peter Yang >> MCSE2000/2003, MCSA, MCDBA >> Microsoft Online Partner Support >> >> When responding to posts, please "Reply to Group" via your newsreader so >> that others may learn and benefit from your issue. >> >> ===================================================== >> >> >> This posting is provided "AS IS" with no warranties, and confers no rights. >> >> >> -------------------- >> >Thread-Topic: No authentication prompt when running report >> >thread-index: AcY/thPOAKype6FWTeSkYUFrw7ffqQ== >> >X-WBNR-Posting-Host: 68.163.226.168 >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >> >Subject: No authentication prompt when running report >> >Date: Sat, 4 Mar 2006 10:04:27 -0800 >> >Lines: 8 >> >Message-ID: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> >> >MIME-Version: 1.0 >> >Content-Type: text/plain; >> > charset="Utf-8" >> >Content-Transfer-Encoding: 7bit >> >X-Newsreader: Microsoft CDO for Windows 2000 >> >Content-Class: urn:content-classes:message >> >Importance: normal >> >Priority: normal >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs >> >Path: TK2MSFTNGXA03.phx.gbl >> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69826 >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs >> > >> >Strange problem: When I go to the reports site, I get prompted to login. >> I >> >can log in successfully. When I attempt to run a report, I should be >> >prompted again. For some reason, I am not getting prompted when running >> the >> >report so I am given an Action canceled, web page could not be found >> error. >> >The strange part is that if I log into the Reports site on the server >> hosting >> >reports, I am prompted this second time and can run the report >> successfully. >> >Does anyone know of any authentication settings that might be causing this >> >behavior? >> > >> >> >
Peter,
The user is a content admin. I have also tried it with the domain admin. The strangest part about this is that I get the second prompt and the report loads successfully when accessing it from the web server. It's only remote connections that have this behavior. [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello, > > This could occur if the user is not in content manager role. You may try to > log on as a user with admin role on SRS to test. > > Best Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > -------------------- > >Thread-Topic: No authentication prompt when running report > >thread-index: AcZBJ94Y028mCY/6RlaHqrRQ/N2R6w== > >X-WBNR-Posting-Host: 149.24.175.16 > >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> > >Subject: RE: No authentication prompt when running report > >Date: Mon, 6 Mar 2006 06:11:31 -0800 > >Lines: 76 > >Message-ID: <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> > >MIME-Version: 1.0 > >Content-Type: text/plain; > > charset="Utf-8" > >Content-Transfer-Encoding: 7bit > >X-Newsreader: Microsoft CDO for Windows 2000 > >Content-Class: urn:content-classes:message > >Importance: normal > >Priority: normal > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > >Newsgroups: microsoft.public.sqlserver.reportingsvcs > >Path: TK2MSFTNGXA03.phx.gbl > >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69866 > >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > > > >Peter, thanks for the reply. Unfortunately, this is not the answer. This > >site is set up in Trusted Zones and it is set to prompt for un/pw. On the > >server, both the Reports and Reports Server vdirs are set to Basic Auth. > The > >domain is not configured to work with windows auth so I should be prompted > >twice. This is the case on a second server I have SQL Reports configured > on > >and it works correctly. Any further ideas? > > > >"Peter Yang [MSFT]" wrote: > > > >> Hello, > >> > >> Basd on my scope, I think it is normal becasue sessionstate/cookies are > >> enabled for report manager. > >> > >> However, if you use Windows authentication, you shall not be prompted to > >> log on in the first place. You may want to check the following IE > settings: > >> > >> Tools->Internet Options->Security->Custom level > >> Under User authentication, check if "Prompt for user name and password" > is > >> selected. > >> > >> Best Regards, > >> > >> Peter Yang > >> MCSE2000/2003, MCSA, MCDBA > >> Microsoft Online Partner Support > >> > >> When responding to posts, please "Reply to Group" via your newsreader so > >> that others may learn and benefit from your issue. > >> > >> ===================================================== > >> > >> > >> This posting is provided "AS IS" with no warranties, and confers no > rights. > >> > >> > >> -------------------- > >> >Thread-Topic: No authentication prompt when running report > >> >thread-index: AcY/thPOAKype6FWTeSkYUFrw7ffqQ== > >> >X-WBNR-Posting-Host: 68.163.226.168 > >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >> >Subject: No authentication prompt when running report > >> >Date: Sat, 4 Mar 2006 10:04:27 -0800 > >> >Lines: 8 > >> >Message-ID: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > >> >MIME-Version: 1.0 > >> >Content-Type: text/plain; > >> > charset="Utf-8" > >> >Content-Transfer-Encoding: 7bit > >> >X-Newsreader: Microsoft CDO for Windows 2000 > >> >Content-Class: urn:content-classes:message > >> >Importance: normal > >> >Priority: normal > >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs > >> >Path: TK2MSFTNGXA03.phx.gbl > >> >Xref: TK2MSFTNGXA03.phx.gbl > microsoft.public.sqlserver.reportingsvcs:69826 > >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >> > > >> >Strange problem: When I go to the reports site, I get prompted to > login. > >> I > >> >can log in successfully. When I attempt to run a report, I should be > >> >prompted again. For some reason, I am not getting prompted when > running > >> the > >> >report so I am given an Action canceled, web page could not be found > >> error. > >> >The strange part is that if I log into the Reports site on the server > >> hosting > >> >reports, I am prompted this second time and can run the report > >> successfully. > >> >Does anyone know of any authentication settings that might be causing > this > >> >behavior? > >> > > >> > >> > > >
Hello Jason,
Based on my further research, this issue might relate to MS04-044. Please refer to the following article for details: Implement a Single-Sign On solution by using basic authentication and Internet Explorer client http://support.microsoft.com/default.aspx?scid=kb;EN-US;837104 You may want to check if you have this update installed. Also, please check if there is any proxy settings on the clients. You may want to check if the issue occurs for Windows XP SP2/Win2003 SP1 machine. If the issue persists, you may want to use netmon to trace the HTTP packets to see the sequence of packets. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- [quoted text, click to view] >Thread-Topic: No authentication prompt when running report <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> >thread-index: AcZB8l1EA1lAKyPXTayL61Ln9Pa+FQ== >X-WBNR-Posting-Host: 149.24.175.16 >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> <G1$RKvbQGHA.5448@TK2MSFTNGXA03.phx.gbl> [quoted text, click to view] >Subject: RE: No authentication prompt when running report
>Date: Tue, 7 Mar 2006 06:21:02 -0800 >Lines: 142 >Message-ID: <FA890089-C850-4F14-B0BC-E0C5F7F2D1FD@microsoft.com> >MIME-Version: 1.0 >Content-Type: text/plain; > charset="Utf-8" >Content-Transfer-Encoding: 7bit >X-Newsreader: Microsoft CDO for Windows 2000 >Content-Class: urn:content-classes:message >Importance: normal >Priority: normal >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >Newsgroups: microsoft.public.sqlserver.reportingsvcs >Path: TK2MSFTNGXA03.phx.gbl >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69951 >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >Peter, > >The user is a content admin. I have also tried it with the domain admin. >The strangest part about this is that I get the second prompt and the report >loads successfully when accessing it from the web server. It's only remote >connections that have this behavior. > >"Peter Yang [MSFT]" wrote: > >> Hello, >> >> This could occur if the user is not in content manager role. You may try to >> log on as a user with admin role on SRS to test. >> >> Best Regards, >> >> Peter Yang >> MCSE2000/2003, MCSA, MCDBA >> Microsoft Online Partner Support >> >> When responding to posts, please "Reply to Group" via your newsreader so >> that others may learn and benefit from your issue. >> >> ===================================================== >> >> This posting is provided "AS IS" with no warranties, and confers no rights. >> >> >> -------------------- >> >Thread-Topic: No authentication prompt when running report >> >thread-index: AcZBJ94Y028mCY/6RlaHqrRQ/N2R6w== >> >X-WBNR-Posting-Host: 149.24.175.16 >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >> >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> >> <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> >> >Subject: RE: No authentication prompt when running report >> >Date: Mon, 6 Mar 2006 06:11:31 -0800 >> >Lines: 76 >> >Message-ID: <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> >> >MIME-Version: 1.0 >> >Content-Type: text/plain; >> > charset="Utf-8" >> >Content-Transfer-Encoding: 7bit >> >X-Newsreader: Microsoft CDO for Windows 2000 >> >Content-Class: urn:content-classes:message >> >Importance: normal >> >Priority: normal >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs >> >Path: TK2MSFTNGXA03.phx.gbl >> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69866 >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs >> > >> >Peter, thanks for the reply. Unfortunately, this is not the answer. This >> >site is set up in Trusted Zones and it is set to prompt for un/pw. On the >> >server, both the Reports and Reports Server vdirs are set to Basic Auth. >> The >> >domain is not configured to work with windows auth so I should be prompted >> >twice. This is the case on a second server I have SQL Reports configured >> on >> >and it works correctly. Any further ideas? >> > >> >"Peter Yang [MSFT]" wrote: >> > >> >> Hello, >> >> >> >> Basd on my scope, I think it is normal becasue sessionstate/cookies are >> >> enabled for report manager. >> >> >> >> However, if you use Windows authentication, you shall not be prompted to >> >> log on in the first place. You may want to check the following IE >> settings: >> >> >> >> Tools->Internet Options->Security->Custom level >> >> Under User authentication, check if "Prompt for user name and password" >> is >> >> selected. >> >> >> >> Best Regards, >> >> >> >> Peter Yang >> >> MCSE2000/2003, MCSA, MCDBA >> >> Microsoft Online Partner Support >> >> >> >> When responding to posts, please "Reply to Group" via your newsreader so >> >> that others may learn and benefit from your issue. >> >> >> >> ===================================================== >> >> >> >> >> >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> >> >> >> -------------------- >> >> >Thread-Topic: No authentication prompt when running report >> >> >thread-index: AcY/thPOAKype6FWTeSkYUFrw7ffqQ== >> >> >X-WBNR-Posting-Host: 68.163.226.168 >> >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >> >> >Subject: No authentication prompt when running report >> >> >Date: Sat, 4 Mar 2006 10:04:27 -0800 >> >> >Lines: 8 >> >> >Message-ID: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> >> >> >MIME-Version: 1.0 >> >> >Content-Type: text/plain; >> >> > charset="Utf-8" >> >> >Content-Transfer-Encoding: 7bit >> >> >X-Newsreader: Microsoft CDO for Windows 2000 >> >> >Content-Class: urn:content-classes:message >> >> >Importance: normal >> >> >Priority: normal >> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >> >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs >> >> >Path: TK2MSFTNGXA03.phx.gbl >> >> >Xref: TK2MSFTNGXA03.phx.gbl >> microsoft.public.sqlserver.reportingsvcs:69826 >> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >> >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs >> >> > >> >> >Strange problem: When I go to the reports site, I get prompted to >> login. >> >> I
Peter,
I've been working with the IIS logs. I wonder if this info could shed a little more light on the situation. This first excerpt is from my client machine where I am not getting the appropriate auth prompt and the report will not render (where xxx.xx.173.3 represents my client IP): 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/js/ReportingServices.js - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/styles/ReportingServices.css - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /aspnet_client/system_web/1_1_4322/WebUIValidation.js - 80 - xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/blank.gif - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/48report.jpg - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/line_err1.gif - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/toolbar_edge_top.gif - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/HideSharedArea.gif - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 2006-03-10 15:11:35 xxx.xx.174.70 GET /Reports/images/toolbar_edge_bottom.gif - 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 This excerpt is when the report is run locally on the server and I get the prompt when running the report. 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 - xxx.xx.174.70 - 401 2 2148074254 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/48report.jpg - 80 sqluser 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/HideSharedArea.gif - 80 sqluser 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 2006-03-10 15:12:48 xxx.xx.174.70 GET /ReportServer %2fSSM+Applicant+Search+Report&rs:Command=Render&rc:ReplacementRoot=http://localhost/Reports/Pages/Report.aspx?ServerUrl= 80 - xxx.xx.174.70 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254 Notice the first difference difference here is after these lines: /ReportServer/reportservice.asmx - 80 On the client, non working machine, I get this: xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 On the local, working machine, I get this: 2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 Is this significant to you? [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello Jason, > > Based on my further research, this issue might relate to MS04-044. Please > refer to the following article for details: > > Implement a Single-Sign On solution by using basic authentication and > Internet Explorer client > http://support.microsoft.com/default.aspx?scid=kb;EN-US;837104 > > You may want to check if you have this update installed. Also, please check > if there is any proxy settings on the clients. You may want to check if the > issue occurs for Windows XP SP2/Win2003 SP1 machine. > > If the issue persists, you may want to use netmon to trace the HTTP packets > to see the sequence of packets. > > Best Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support >
Peter,
I wish you could edit these posts...I've made a copy error from the logs. See below. After the 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 lines, the client machine trying to access the report is logging: 2006-03-10 15:11:29 149.24.174.70 GET /Reports/Pages/Report.aspx ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser xxx.xx.176.3 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 while the local machine accessing the report is logging: 2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/48report.jpg - 80 sqluser 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 This is not occuring on the client machine: 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200 0 0 Can you think of a reason why? [quoted text, click to view] "Jason" wrote:
> Peter, > > I've been working with the IIS logs. I wonder if this info could shed a > little more light on the situation. This first excerpt is from my client > machine where I am not getting the appropriate auth prompt and the report > will not render (where xxx.xx.173.3 represents my client IP): > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/js/ReportingServices.js - 80 > sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/styles/ReportingServices.css > - 80 sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET > /aspnet_client/system_web/1_1_4322/WebUIValidation.js - 80 - xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/blank.gif - 80 sqluser > xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/48report.jpg - 80 > sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/line_err1.gif - 80 > sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/toolbar_edge_top.gif - > 80 sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/HideSharedArea.gif - > 80 sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > 2006-03-10 15:11:35 xxx.xx.174.70 GET > /Reports/images/toolbar_edge_bottom.gif - 80 sqluser xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > > > This excerpt is when the report is run locally on the server and I get the > prompt when running the report. > > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > - xxx.xx.174.70 - 401 2 2148074254 > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > 2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx > ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 200 0 0 > 2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/48report.jpg - 80 sqluser > 127.0.0.1 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 200 0 0 > 2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/HideSharedArea.gif - 80 > sqluser 127.0.0.1 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 200 0 0 > 2006-03-10 15:12:48 xxx.xx.174.70 GET /ReportServer > %2fSSM+Applicant+Search+Report&rs:Command=Render&rc:ReplacementRoot=http://localhost/Reports/Pages/Report.aspx?ServerUrl= > 80 - xxx.xx.174.70 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 401 2 2148074254 > > >
Jason, Peter,
I am having the exact same problem. It appears that credential information is being automatically in some cases, but apparently is not doing it properly. I will try to implement the fix contained in your KB article. Just wanted to let you know you're not alone. [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello Jason, > > Based on my further research, this issue might relate to MS04-044. Please > refer to the following article for details: > > Implement a Single-Sign On solution by using basic authentication and > Internet Explorer client > http://support.microsoft.com/default.aspx?scid=kb;EN-US;837104 > > You may want to check if you have this update installed. Also, please check > if there is any proxy settings on the clients. You may want to check if the > issue occurs for Windows XP SP2/Win2003 SP1 machine. > > If the issue persists, you may want to use netmon to trace the HTTP packets > to see the sequence of packets. > > Best Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > -------------------- > >Thread-Topic: No authentication prompt when running report > >thread-index: AcZB8l1EA1lAKyPXTayL61Ln9Pa+FQ== > >X-WBNR-Posting-Host: 149.24.175.16 > >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> > <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> > <G1$RKvbQGHA.5448@TK2MSFTNGXA03.phx.gbl> > >Subject: RE: No authentication prompt when running report > >Date: Tue, 7 Mar 2006 06:21:02 -0800 > >Lines: 142 > >Message-ID: <FA890089-C850-4F14-B0BC-E0C5F7F2D1FD@microsoft.com> > >MIME-Version: 1.0 > >Content-Type: text/plain; > > charset="Utf-8" > >Content-Transfer-Encoding: 7bit > >X-Newsreader: Microsoft CDO for Windows 2000 > >Content-Class: urn:content-classes:message > >Importance: normal > >Priority: normal > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > >Newsgroups: microsoft.public.sqlserver.reportingsvcs > >Path: TK2MSFTNGXA03.phx.gbl > >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69951 > >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > > > >Peter, > > > >The user is a content admin. I have also tried it with the domain admin. > >The strangest part about this is that I get the second prompt and the > report > >loads successfully when accessing it from the web server. It's only > remote > >connections that have this behavior. > > > >"Peter Yang [MSFT]" wrote: > > > >> Hello, > >> > >> This could occur if the user is not in content manager role. You may try > to > >> log on as a user with admin role on SRS to test. > >> > >> Best Regards, > >> > >> Peter Yang > >> MCSE2000/2003, MCSA, MCDBA > >> Microsoft Online Partner Support > >> > >> When responding to posts, please "Reply to Group" via your newsreader so > >> that others may learn and benefit from your issue. > >> > >> ===================================================== > >> > >> This posting is provided "AS IS" with no warranties, and confers no > rights. > >> > >> > >> -------------------- > >> >Thread-Topic: No authentication prompt when running report > >> >thread-index: AcZBJ94Y028mCY/6RlaHqrRQ/N2R6w== > >> >X-WBNR-Posting-Host: 149.24.175.16 > >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >> >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > >> <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> > >> >Subject: RE: No authentication prompt when running report > >> >Date: Mon, 6 Mar 2006 06:11:31 -0800 > >> >Lines: 76 > >> >Message-ID: <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> > >> >MIME-Version: 1.0 > >> >Content-Type: text/plain; > >> > charset="Utf-8" > >> >Content-Transfer-Encoding: 7bit > >> >X-Newsreader: Microsoft CDO for Windows 2000 > >> >Content-Class: urn:content-classes:message > >> >Importance: normal > >> >Priority: normal > >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs > >> >Path: TK2MSFTNGXA03.phx.gbl > >> >Xref: TK2MSFTNGXA03.phx.gbl > microsoft.public.sqlserver.reportingsvcs:69866 > >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >> > > >> >Peter, thanks for the reply. Unfortunately, this is not the answer. > This > >> >site is set up in Trusted Zones and it is set to prompt for un/pw. On > the > >> >server, both the Reports and Reports Server vdirs are set to Basic > Auth. > >> The > >> >domain is not configured to work with windows auth so I should be > prompted > >> >twice. This is the case on a second server I have SQL Reports > configured > >> on > >> >and it works correctly. Any further ideas? > >> > > >> >"Peter Yang [MSFT]" wrote: > >> > > >> >> Hello, > >> >> > >> >> Basd on my scope, I think it is normal becasue sessionstate/cookies > are > >> >> enabled for report manager. > >> >> > >> >> However, if you use Windows authentication, you shall not be prompted > to > >> >> log on in the first place. You may want to check the following IE > >> settings: > >> >> > >> >> Tools->Internet Options->Security->Custom level > >> >> Under User authentication, check if "Prompt for user name and > password" > >> is > >> >> selected. > >> >> > >> >> Best Regards, > >> >> > >> >> Peter Yang > >> >> MCSE2000/2003, MCSA, MCDBA > >> >> Microsoft Online Partner Support > >> >> > >> >> When responding to posts, please "Reply to Group" via your newsreader > so > >> >> that others may learn and benefit from your issue. > >> >> > >> >> ===================================================== > >> >> > >> >> > >> >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> >> > >> >> > >> >> -------------------- > >> >> >Thread-Topic: No authentication prompt when running report > >> >> >thread-index: AcY/thPOAKype6FWTeSkYUFrw7ffqQ== > >> >> >X-WBNR-Posting-Host: 68.163.226.168 > >> >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >> >> >Subject: No authentication prompt when running report > >> >> >Date: Sat, 4 Mar 2006 10:04:27 -0800 > >> >> >Lines: 8 > >> >> >Message-ID: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > >> >> >MIME-Version: 1.0 > >> >> >Content-Type: text/plain; > >> >> > charset="Utf-8" > >> >> >Content-Transfer-Encoding: 7bit
Jason, Peter,
I was able to find the solution to my problem - it boiled down to a name resolution problem. I am hoping this may help you with your problem. I installed an HTTP logging tool for my client machine. I found a free one called HttpWatch. [ The product installs a toolbar button in Explorer - click on it to get the Watch window. Press Record to start logging browser requests. ] What i noticed is that the when my report loaded, all images loaded fine, except for the frame which is supposed to display the actual report. In that frame, I get a 'page cannot be displayed' error. I matched the HTTP request for this frame to an HTTP error ( ERROR_INTERNET_NAME_NOT_RESOLVED) in the HttpWatch log. The HTTP request for that frame was apparently using the name of the server that is *only visible inside the company intranet*. This means that the report would only display properly if Reporting Services was running on the same machine as the client browser, or within the intranet. I think the frame is using the internal name of the server because of a setting configured when Reporting Services was installed. So, one fix may be to reinstall RS and use a server name that resolves in the intranet and on the global internet. I am currently fishing through config files and the registry to see if reinstall is not necessary. If I find it, I'll post another reply. [ Note, if you only care about getting access from your own machine, you can manually add a name-server/ip address mapping in the file c:/Windows/System32/Drivers/Etc/Hosts. Of course, this is not likely a good solution for the intended audience of your report ! ] Good luck, George Williams. [quoted text, click to view] "Jason" wrote:
> Peter, > I wish you could edit these posts...I've made a copy error from the logs. > See below. After the > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > lines, the client machine trying to access the report is logging: > > 2006-03-10 15:11:29 149.24.174.70 GET /Reports/Pages/Report.aspx > ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser > xxx.xx.176.3 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 > > while the local machine accessing the report is logging: > > 2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx > ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 200 0 0 > 2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/48report.jpg - 80 sqluser > 127.0.0.1 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 200 0 0 > > This is not occuring on the client machine: > 127.0.0.1 > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > 200 0 0 > > Can you think of a reason why? > > > > > > "Jason" wrote: > > > Peter, > > > > I've been working with the IIS logs. I wonder if this info could shed a > > little more light on the situation. This first excerpt is from my client > > machine where I am not getting the appropriate auth prompt and the report > > will not render (where xxx.xx.173.3 represents my client IP): > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > - xxx.xx.174.70 - 401 2 2148074254 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > - xxx.xx.174.70 - 401 2 2148074254 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > - xxx.xx.174.70 - 401 2 2148074254 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > - xxx.xx.174.70 - 401 2 2148074254 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > - xxx.xx.174.70 - 401 2 2148074254 > > 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > > xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/js/ReportingServices.js - 80 > > sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/styles/ReportingServices.css > > - 80 sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET > > /aspnet_client/system_web/1_1_4322/WebUIValidation.js - 80 - xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/blank.gif - 80 sqluser > > xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/48report.jpg - 80 > > sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/line_err1.gif - 80 > > sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/toolbar_edge_top.gif - > > 80 sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/HideSharedArea.gif - > > 80 sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > 2006-03-10 15:11:35 xxx.xx.174.70 GET > > /Reports/images/toolbar_edge_bottom.gif - 80 sqluser xxx.xx.176.3 > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0 > > > > > > > > This excerpt is when the report is run locally on the server and I get the > > prompt when running the report. > > > > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 > > - xxx.xx.174.70 - 401 2 2148074254 > > 2006-03-10 15:12:48 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80
Peter, George,
I resolved this issue on Friday afternoon and came in this morning to see that the resolution had been posted here as well. It did end up being a DNS issue. I changed the Report Server URL in the RSWebApplication.config to reflect the web machine's IP and I can now load the report. I'm still not sure why it doesn't prompt me a second time (as it does successfully in a second similarly structured domain) but the reports are now loading which is what I'm more concerned with. Thanks so much for your attention and time. Jason [quoted text, click to view] "gw1128" wrote:
> Jason, Peter, > > I am having the exact same problem. It appears that credential information > is being automatically in some cases, but apparently is not doing it > properly. I will try to implement the fix contained in your KB article. > > Just wanted to let you know you're not alone. > > "Peter Yang [MSFT]" wrote: > > > Hello Jason, > > > > Based on my further research, this issue might relate to MS04-044. Please > > refer to the following article for details: > > > > Implement a Single-Sign On solution by using basic authentication and > > Internet Explorer client > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;837104 > > > > You may want to check if you have this update installed. Also, please check > > if there is any proxy settings on the clients. You may want to check if the > > issue occurs for Windows XP SP2/Win2003 SP1 machine. > > > > If the issue persists, you may want to use netmon to trace the HTTP packets > > to see the sequence of packets. > > > > Best Regards, > > > > Peter Yang > > MCSE2000/2003, MCSA, MCDBA > > Microsoft Online Partner Support > > > > When responding to posts, please "Reply to Group" via your newsreader so > > that others may learn and benefit from your issue. > > > > ===================================================== > > > > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > > -------------------- > > >Thread-Topic: No authentication prompt when running report > > >thread-index: AcZB8l1EA1lAKyPXTayL61Ln9Pa+FQ== > > >X-WBNR-Posting-Host: 149.24.175.16 > > >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > > >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > > <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> > > <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> > > <G1$RKvbQGHA.5448@TK2MSFTNGXA03.phx.gbl> > > >Subject: RE: No authentication prompt when running report > > >Date: Tue, 7 Mar 2006 06:21:02 -0800 > > >Lines: 142 > > >Message-ID: <FA890089-C850-4F14-B0BC-E0C5F7F2D1FD@microsoft.com> > > >MIME-Version: 1.0 > > >Content-Type: text/plain; > > > charset="Utf-8" > > >Content-Transfer-Encoding: 7bit > > >X-Newsreader: Microsoft CDO for Windows 2000 > > >Content-Class: urn:content-classes:message > > >Importance: normal > > >Priority: normal > > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > > >Newsgroups: microsoft.public.sqlserver.reportingsvcs > > >Path: TK2MSFTNGXA03.phx.gbl > > >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69951 > > >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > > >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > > > > > >Peter, > > > > > >The user is a content admin. I have also tried it with the domain admin. > > >The strangest part about this is that I get the second prompt and the > > report > > >loads successfully when accessing it from the web server. It's only > > remote > > >connections that have this behavior. > > > > > >"Peter Yang [MSFT]" wrote: > > > > > >> Hello, > > >> > > >> This could occur if the user is not in content manager role. You may try > > to > > >> log on as a user with admin role on SRS to test. > > >> > > >> Best Regards, > > >> > > >> Peter Yang > > >> MCSE2000/2003, MCSA, MCDBA > > >> Microsoft Online Partner Support > > >> > > >> When responding to posts, please "Reply to Group" via your newsreader so > > >> that others may learn and benefit from your issue. > > >> > > >> ===================================================== > > >> > > >> This posting is provided "AS IS" with no warranties, and confers no > > rights. > > >> > > >> > > >> -------------------- > > >> >Thread-Topic: No authentication prompt when running report > > >> >thread-index: AcZBJ94Y028mCY/6RlaHqrRQ/N2R6w== > > >> >X-WBNR-Posting-Host: 149.24.175.16 > > >> >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > > >> >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > > >> <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> > > >> >Subject: RE: No authentication prompt when running report > > >> >Date: Mon, 6 Mar 2006 06:11:31 -0800 > > >> >Lines: 76 > > >> >Message-ID: <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> > > >> >MIME-Version: 1.0 > > >> >Content-Type: text/plain; > > >> > charset="Utf-8" > > >> >Content-Transfer-Encoding: 7bit > > >> >X-Newsreader: Microsoft CDO for Windows 2000 > > >> >Content-Class: urn:content-classes:message > > >> >Importance: normal > > >> >Priority: normal > > >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > > >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs > > >> >Path: TK2MSFTNGXA03.phx.gbl > > >> >Xref: TK2MSFTNGXA03.phx.gbl > > microsoft.public.sqlserver.reportingsvcs:69866 > > >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > > >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > > >> > > > >> >Peter, thanks for the reply. Unfortunately, this is not the answer. > > This > > >> >site is set up in Trusted Zones and it is set to prompt for un/pw. On > > the > > >> >server, both the Reports and Reports Server vdirs are set to Basic > > Auth. > > >> The > > >> >domain is not configured to work with windows auth so I should be > > prompted > > >> >twice. This is the case on a second server I have SQL Reports > > configured > > >> on > > >> >and it works correctly. Any further ideas? > > >> > > > >> >"Peter Yang [MSFT]" wrote: > > >> > > > >> >> Hello, > > >> >> > > >> >> Basd on my scope, I think it is normal becasue sessionstate/cookies > > are > > >> >> enabled for report manager. > > >> >> > > >> >> However, if you use Windows authentication, you shall not be prompted > > to > > >> >> log on in the first place. You may want to check the following IE > > >> settings: > > >> >> > > >> >> Tools->Internet Options->Security->Custom level > > >> >> Under User authentication, check if "Prompt for user name and > > password" > > >> is > > >> >> selected. > > >> >> > > >> >> Best Regards, > > >> >> > > >> >> Peter Yang > > >> >> MCSE2000/2003, MCSA, MCDBA > > >> >> Microsoft Online Partner Support > > >> >>
Hello Jason,
According to the sympotms, it seems to be related to FQDN or name resolution. How did you configure <ReportServerUrl> in RSWebApplication.Config? How did you configure <UrlRoot> in RSReportServer.Config ? If you change them to FQDN URL, what is the result? Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- [quoted text, click to view] >Thread-Topic: No authentication prompt when running report <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> >thread-index: AcZEW8BaYkx8GQbqTJaDcq6WbOFFKQ== >X-WBNR-Posting-Host: 149.24.175.16 >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> <G1$RKvbQGHA.5448@TK2MSFTNGXA03.phx.gbl> <FA890089-C850-4F14-B0BC-E0C5F7F2D1FD@microsoft.com> <jKfd92lQGHA.6824@TK2MSFTNGXA03.phx.gbl> <62F62F21-6FC3-40B1-AEB7-CF5D94B71BCD@microsoft.com> [quoted text, click to view] >Subject: RE: No authentication prompt when running report Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C>Date: Fri, 10 Mar 2006 08:00:28 -0800 >Lines: 335 >Message-ID: <F8A2D269-D832-46D2-8905-3D35BAE537C8@microsoft.com> >MIME-Version: 1.0 >Content-Type: text/plain; > charset="Utf-8" >Content-Transfer-Encoding: 7bit >X-Newsreader: Microsoft CDO for Windows 2000 >Content-Class: urn:content-classes:message >Importance: normal >Priority: normal >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 >Newsgroups: microsoft.public.sqlserver.reportingsvcs >Path: TK2MSFTNGXA03.phx.gbl >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:70239 >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >Peter, >I wish you could edit these posts...I've made a copy error from the logs. >See below. After the >2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >lines, the client machine trying to access the report is logging: > >2006-03-10 15:11:29 149.24.174.70 GET /Reports/Pages/Report.aspx >ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser >xxx.xx.176.3 >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+ CLR+2.0.50727) 200 0 0 > >while the local machine accessing the report is logging: > >2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx >ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) >200 0 0 >2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/48report.jpg - 80 sqluser >127.0.0.1 >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) >200 0 0 > >This is not occuring on the client machine: >127.0.0.1 >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) >200 0 0 > >Can you think of a reason why? > > > > > >"Jason" wrote: > >> Peter, >> >> I've been working with the IIS logs. I wonder if this info could shed a >> little more light on the situation. This first excerpt is from my client >> machine where I am not getting the appropriate auth prompt and the report >> will not render (where xxx.xx.173.3 represents my client IP): >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> - xxx.xx.174.70 - 401 2 2148074254 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> - xxx.xx.174.70 - 401 2 2148074254 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> - xxx.xx.174.70 - 401 2 2148074254 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> - xxx.xx.174.70 - 401 2 2148074254 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> - xxx.xx.174.70 - 401 2 2148074254 >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - 80 >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 >> xxx.xx.176.3 >> LR+2.0.50727) 200 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/js/ReportingServices.js - Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C80 >> sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C/Reports/styles/ReportingServices.css >> - 80 sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C>> /aspnet_client/system_web/1_1_4322/WebUIValidation.js - 80 - xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/blank.gif - 80 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+Csqluser >> xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/48report.jpg - 80 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C>> sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/line_err1.gif - 80 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C>> sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C/Reports/images/toolbar_edge_top.gif - >> 80 sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/HideSharedArea.gif Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C- >> 80 sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >> 2006-03-10 15:11:35 xxx.xx.174.70 GET Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C>> /Reports/images/toolbar_edge_bottom.gif - 80 sqluser xxx.xx.176.3 >> LR+2.0.50727) 304 0 0 [quoted text, click to view] >>
>> >> >> This excerpt is when the report is run locally on the server and I get the >> prompt when running the report. >>
Peter,
Apparently, there is another config entry in RSReportServer.Config that you can add to resolve this problem. There are other posts in this forum about it - but it looks like this: <ReportServerExternalUrl></ReportServerExternalUrl> Obviously, you set the proper,externally visible url inside the tag. It worked for me! Notes: 1) the spelling and caps are very important for the tag. 2) for more details about this config file entry, you can search the Reporting Services help. [quoted text, click to view] "Peter Yang [MSFT]" wrote:
> Hello Jason, > > According to the sympotms, it seems to be related to FQDN or name > resolution. How did you configure <ReportServerUrl> in > RSWebApplication.Config? How > did you configure <UrlRoot> in RSReportServer.Config ? If you change them > to FQDN URL, what is the result? > > Best Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ===================================================== > > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > -------------------- > >Thread-Topic: No authentication prompt when running report > >thread-index: AcZEW8BaYkx8GQbqTJaDcq6WbOFFKQ== > >X-WBNR-Posting-Host: 149.24.175.16 > >From: =?Utf-8?B?SmFzb24=?= <Jason@discussions.microsoft.com> > >References: <7122426F-0596-4FED-86C8-82EFB768EB88@microsoft.com> > <A2nfhDOQGHA.944@TK2MSFTNGXA03.phx.gbl> > <274E132B-C794-4406-BBA5-6D3CF04796F1@microsoft.com> > <G1$RKvbQGHA.5448@TK2MSFTNGXA03.phx.gbl> > <FA890089-C850-4F14-B0BC-E0C5F7F2D1FD@microsoft.com> > <jKfd92lQGHA.6824@TK2MSFTNGXA03.phx.gbl> > <62F62F21-6FC3-40B1-AEB7-CF5D94B71BCD@microsoft.com> > >Subject: RE: No authentication prompt when running report > >Date: Fri, 10 Mar 2006 08:00:28 -0800 > >Lines: 335 > >Message-ID: <F8A2D269-D832-46D2-8905-3D35BAE537C8@microsoft.com> > >MIME-Version: 1.0 > >Content-Type: text/plain; > > charset="Utf-8" > >Content-Transfer-Encoding: 7bit > >X-Newsreader: Microsoft CDO for Windows 2000 > >Content-Class: urn:content-classes:message > >Importance: normal > >Priority: normal > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 > >Newsgroups: microsoft.public.sqlserver.reportingsvcs > >Path: TK2MSFTNGXA03.phx.gbl > >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:70239 > >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 > >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > > > >Peter, > >I wish you could edit these posts...I've made a copy error from the logs. > >See below. After the > >2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx - > 80 > >lines, the client machine trying to access the report is logging: > > > >2006-03-10 15:11:29 149.24.174.70 GET /Reports/Pages/Report.aspx > >ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser > >xxx.xx.176.3 > >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+ > CLR+2.0.50727) 200 0 0 > > > >while the local machine accessing the report is logging: > > > >2006-03-10 15:12:48 127.0.0.1 GET /Reports/Pages/Report.aspx > >ItemPath=%2fSSM+Applicant+Search+Report 80 sqluser 127.0.0.1 > >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > >200 0 0 > >2006-03-10 15:12:48 127.0.0.1 GET /Reports/images/48report.jpg - 80 > sqluser > >127.0.0.1 > >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > >200 0 0 > > > >This is not occuring on the client machine: > >127.0.0.1 > >Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) > >200 0 0 > > > >Can you think of a reason why? > > > > > > > > > > > >"Jason" wrote: > > > >> Peter, > >> > >> I've been working with the IIS logs. I wonder if this info could shed a > >> little more light on the situation. This first excerpt is from my > client > >> machine where I am not getting the appropriate auth prompt and the > report > >> will not render (where xxx.xx.173.3 represents my client IP): > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> - xxx.xx.174.70 - 401 2 2148074254 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> - xxx.xx.174.70 - 401 2 2148074254 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> - xxx.xx.174.70 - 401 2 2148074254 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> - xxx.xx.174.70 - 401 2 2148074254 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> - xxx.xx.174.70 - 401 2 2148074254 > >> 2006-03-10 15:11:29 xxx.xx.174.70 POST /ReportServer/reportservice.asmx > - 80 > >> CAMMXSS2\sqluser xxx.xx.174.70 - 200 0 0 > >> xxx.xx.176.3 > >> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C > LR+2.0.50727) 200 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/js/ReportingServices.js - > 80 > >> sqluser xxx.xx.176.3 > >> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C > LR+2.0.50727) 304 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 GET > /Reports/styles/ReportingServices.css > >> - 80 sqluser xxx.xx.176.3 > >> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C > LR+2.0.50727) 304 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 GET > >> /aspnet_client/system_web/1_1_4322/WebUIValidation.js - 80 - > xxx.xx.176.3 > >> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C > LR+2.0.50727) 304 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/blank.gif - 80 > sqluser > >> xxx.xx.176.3 > >> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C > LR+2.0.50727) 304 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/48report.jpg - 80 > >> sqluser xxx.xx.176.3 > >> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322;+.NET+C > LR+2.0.50727) 304 0 0 > >> 2006-03-10 15:11:29 xxx.xx.174.70 GET /Reports/images/line_err1.gif - 80 > >> sqluser xxx.xx.176.3 > >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |