Reporting Services using NTLM Authentication

I need to have MSSRS send emails to external email addresses. Our Exchange
Server requires email to be authenticated. I am using SMTPAuthenticate value
of 2. My MSSRS server is in a different domain than my Exchange Mail server.
Currently I am testing before deployment into the field and my setup is
mirroring what the corporate desired setup is.
I receive the following error when I attempt to send a report to an external
email:
Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x80040217. The server response was not available
When I sniff the traffic during the report serving, my local Admin login
account is being authenticated by the Exchange Server in the mailer domain.
What type of setup or config changes can be made for the proper hand shake to
work? I must send authenticated email externally to our customers, but the
MSSRS Server and Exchange Servers will be in different domains.
Thanks,
RobertGood morning!
Did you ever find the solution to your question below? If so, what did you
do to resolve it?
Thank you.
"gilliatt via SQLMonster.com" wrote:
> I need to have MSSRS send emails to external email addresses. Our Exchange
> Server requires email to be authenticated. I am using SMTPAuthenticate value
> of 2. My MSSRS server is in a different domain than my Exchange Mail server.
> Currently I am testing before deployment into the field and my setup is
> mirroring what the corporate desired setup is.
> I receive the following error when I attempt to send a report to an external
> email:
> Failure sending mail: The message could not be sent to the SMTP server. The
> transport error code was 0x80040217. The server response was not available
> When I sniff the traffic during the report serving, my local Admin login
> account is being authenticated by the Exchange Server in the mailer domain.
> What type of setup or config changes can be made for the proper hand shake to
> work? I must send authenticated email externally to our customers, but the
> MSSRS Server and Exchange Servers will be in different domains.
> Thanks,
> Robert
>sql

Reporting Services Report Manager Authentication Issue

Hi,

I have installed Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report.

Is there any way to disable this windows authentication dialouge box?

Regards,

PS: in the viewer i give the path of the report as http://localhost/Rerport/ABC.rdlThis forum is on .Net Framework (CLR) integration in SQL Server 2005 that allows you to write routines in CLR languages like c#, VB.NET etc.
I suggest posting your question in SQL Server Reporting Services forum to get a faster response.

Thanks,
-Vineet.

Reporting Services Over the Internet

Can anybody help.
I want to run reporting services on a web server (DMZ and Firewall) and use
NT authentication, but when i try to run a report and the data source falls
over saying it can not found the login.
I have created the login (test) on both the Domain and web server (same
password)
Regards
Gary
Direct e-mail gary.baker@.mentec.co.ukI assume you've tried SQL Login instead of NT Auth for your data source?
And the SQL box and web server are both in the same domain?
Jeff
"Gary Baker" <gary.baker@.mentec.co.uk> wrote in message
news:OpKj#IllEHA.2820@.TK2MSFTNGP15.phx.gbl...
> Can anybody help.
> I want to run reporting services on a web server (DMZ and Firewall) and
use
> NT authentication, but when i try to run a report and the data source
falls
> over saying it can not found the login.
> I have created the login (test) on both the Domain and web server (same
> password)
> Regards
>
> Gary
>
> Direct e-mail gary.baker@.mentec.co.uk
>

Reporting Services Not Asking For Authentication

I have made sure that anonymous logins are disabled on the reports and
reportserver virtual directories. When I setup reporting services, I
made sure that the use SSL connections checkbox was checked. I don't
understand why its not asking for authentication.
I also made sure that I didn't have the site's certificate installed.
Thanks in advance.Hi Scott:
Is your report server URL one of your Trusted Sites? Or, is it in the
Intranet content zone? If so, your network credentials are automatically
being passed to the report server thus skipping over the login window. I hope
this helps yoiu.
Jeff Roberts
"Scott" wrote:
> I have made sure that anonymous logins are disabled on the reports and
> reportserver virtual directories. When I setup reporting services, I
> made sure that the use SSL connections checkbox was checked. I don't
> understand why its not asking for authentication.
> I also made sure that I didn't have the site's certificate installed.
> Thanks in advance.
>

Reporting Services Mode

I need to do an asp.net application that has reports and Forms Authentication
(no windows authentication). I have absolutely NO need for centralized
reports or load balancing.
On my last project I used sql05 reports within asp.net vs05 on a win03/32bit
server and used LOCAL reports.
The good things
Software configuration management was easy because the reports were local.
The bad things
Rendering in Firefox/mozilla - was very very very poor
Report features for browsers other than IE was poor (searching bookmarks)
Exporting large reports >20 meg - crashes IIS
Would the bad things get better if I:
1. Put in links from my asp.net app to the reporting services web site
or
2. Use the asp.net reportviewer but link to reports on the reporting
services server.
As I see it
Doing 1 or 2 would involve some new security; I would like to use my
applications FormAuthentication, which is not against Windows accounts.
Doing 1 or 2 would complicate my software configuration management.
Doing 1 or 2 would complicate my development and deployment infrastructure.
Doing 1 would degrade the look and feel of my application.
Would doing all the extra work involved with 1 or 2, reduce crashing or
improve rendering in Firefox? I don't understand what the real-physical
differences are between running local or on Report Server, other than
distributing the load. I also don't understand why you lose some export
modes when running local reports, but suspect it has to do with licensing.
Your suggestions are appreciated.
thanks,
p.s. I am upgrading the OS to win03 64bit to reduce IIS crashing during
export.Hello Chunk,
The report viewer control Browser Compatiblity with firefox will be
improved in the Visual Studio .Net 2005 SP1.
If you have any specific issue with Firefox, you could send your feedback
to the product team:
http://connect.microsoft.com/
As for the export type, this is by design. Also, you could send your
feedback to the product team if you have any suggestion.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Is there any difference in rendering between local reports and reports
servered off of the Report Server?|||Hello Chunk,
The main difference between the local processing mode and remote processing
mode is that in local processing mode, your application will retrieve and
render the report while in remote mode, report server will retrieve and
render the report.
You could refer this article for more detailed information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
l/integratrsapp.asp
Sincerely,
Wei Lu
Microsoft Online Community 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.|||This question came up because one of our developers went through a really bad
time with the Report Viewer control and Firefox. She believes the
ReportViewer Control is evil and we should just give links to the reports
hosted on the Report Server so we don't have to use the Report Viewer.
If we did this some of our asp.net apps would loose their look and feel
because the reports would no longer be embedded. Personally, I don't think
it would render any different. The article you referenced didn't really get
that technical on the rendering of embedded reports.
"Wei Lu [MSFT]" wrote:
> Hello Chunk,
> The main difference between the local processing mode and remote processing
> mode is that in local processing mode, your application will retrieve and
> render the report while in remote mode, report server will retrieve and
> render the report.
> You could refer this article for more detailed information:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
> l/integratrsapp.asp
>
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Before going to using links you better test. I think firefox has problems
with reports period, regardless of how you do it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chuck P" <Chuck@.newsgroup.nospam> wrote in message
news:7454D820-CBDD-4BED-A8E7-6BC0DADE2E69@.microsoft.com...
> This question came up because one of our developers went through a really
> bad
> time with the Report Viewer control and Firefox. She believes the
> ReportViewer Control is evil and we should just give links to the reports
> hosted on the Report Server so we don't have to use the Report Viewer.
> If we did this some of our asp.net apps would loose their look and feel
> because the reports would no longer be embedded. Personally, I don't
> think
> it would render any different. The article you referenced didn't really
> get
> that technical on the rendering of embedded reports.
>
>
> "Wei Lu [MSFT]" wrote:
>> Hello Chunk,
>> The main difference between the local processing mode and remote
>> processing
>> mode is that in local processing mode, your application will retrieve and
>> render the report while in remote mode, report server will retrieve and
>> render the report.
>> You could refer this article for more detailed information:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
>> l/integratrsapp.asp
>>
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community 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.
>>|||That was my guess. I would imagine the rendering dll would be the same on
the Report Server or locally. However, it can't be identical because you get
less output options if you render locally.|||Hello Chunk,
If you could provide some detailed information about what error or what
behavior that you could not get the report render correctly in the FireFox,
I will be appreciated.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Most of them are described in MSDN community forums.
Search on ReportViewer and FireFox
http://forums.microsoft.com/MSDN/Search/Search.aspx?words=firefox&searchKey=&lcid=1033&searchscope=forumscope&siteid=1&ForumID=75&ForumGroupID=-1&GoButton=+Go+
The HyperLinkTarget failure is bad:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=333437&SiteID=1
If you have links in the report, without a target=_self, if you place a
href in the report the link will open in the iframe of the report viewer.
This only true for pages after the inital page page 1 the viewer behaves
properly.
Shrinking tables (use a hidden textbox) is widely discussed
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=248271&SiteID=1
There is a good article on the code project on how to place the viewer for
better rendering.
http://www.codeproject.com/sqlrs/ReportViewer2005.asp
ToolBar Display Issue:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354888&SiteID=1
Would be great to get a KB article that would document all the issues/work
arounds in one place!|||Hello Chuck,
Thanks for the feedback. Since the compatibility of FireFox for reporting
service will be improved in the Visual Studio .Net 2005 SP1, the product
team will provide some KB article together with SP1 release.
You could download the beta version and try to test do those issue resolved.
Here is the download url for Visual Studio 2005 Service Pack 1 Beta
http://www.microsoft.com/downloads/details.aspx?familyid=8D702463-674B-4978-
9E22-C989130F6553&displaylang=en
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

Reporting Services IIS authentication

Hi
SQL 2005 was first installed on a Win 2003 Server sans the Reporting
Services because IIS was not installed. Then we installed IIS and then
RS and then reapplied SP2 for SQL2005. RS runs under an appPool that
is configured with a local account that has admin priv. I log into an
AD domain account, my domain account is also in the local admins group
on this server.
On an XP client using IE I try to browse to the reports virtual
directory and am prompted for credentials. It looks like the web page
wants to display but the images are not shown. When I hit cancel in
the credentials box one of the missing images now displays the missing
image icon. I do this 5 or 6 times to get the credentials box to go
away. I am now looking at the Home page (with no images) It is almost
as if my account doesn't have permissions to read the image files even
though I am an admin on the machine. Note: I tried many username/
passwords in the credentials box including domain admins to no avail.
I don't get much farther than this, when I click on a link such as
Site Settings, sometimes it will take me to the page but most times it
will display the "You are not authorized to view this page" message.
[As an aside, a couple times after clicking cancel many times in
response to the credentials box it let me navigate all of the links
and displayed all of the images. When I would close the browser and
try again the credentials box issue was back. Getting it to work like
this is not repeatable]
I dropped an aspx page into the ReportManager folder (same one that
contains the Home.aspx) that contains this:
id=windowsidentity.getcurrent()
if not id is nothing then
windows.Text = "WindowsIdentitly.GetCurrent(): " &
id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
id.AuthenticationType
end if
When I browse to this page it shows that the RS site IS authenticating
my domain account [DOMAIN\username] but the authentication type is
NTLM. On another server where I have RS working this same page shows
Kerberos.
I am at wits end. Thank you in advance for any help
ScotCheck the IIS logs and see what the HTTP Code was for the image file
access. That should help you start pinpointing where the authentication
issue resides.
Once you get those log entries you can post them here and I'll take a look
and see if I can help.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: scot.hauder@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Reporting Services IIS authentication
> Date: Thu, 04 Oct 2007 12:53:54 -0700
> Hi
> SQL 2005 was first installed on a Win 2003 Server sans the Reporting
> Services because IIS was not installed. Then we installed IIS and then
> RS and then reapplied SP2 for SQL2005. RS runs under an appPool that
> is configured with a local account that has admin priv. I log into an
> AD domain account, my domain account is also in the local admins group
> on this server.
> On an XP client using IE I try to browse to the reports virtual
> directory and am prompted for credentials. It looks like the web page
> wants to display but the images are not shown. When I hit cancel in
> the credentials box one of the missing images now displays the missing
> image icon. I do this 5 or 6 times to get the credentials box to go
> away. I am now looking at the Home page (with no images) It is almost
> as if my account doesn't have permissions to read the image files even
> though I am an admin on the machine. Note: I tried many username/
> passwords in the credentials box including domain admins to no avail.
> I don't get much farther than this, when I click on a link such as
> Site Settings, sometimes it will take me to the page but most times it
> will display the "You are not authorized to view this page" message.
> [As an aside, a couple times after clicking cancel many times in
> response to the credentials box it let me navigate all of the links
> and displayed all of the images. When I would close the browser and
> try again the credentials box issue was back. Getting it to work like
> this is not repeatable]
> I dropped an aspx page into the ReportManager folder (same one that
> contains the Home.aspx) that contains this:
> id=windowsidentity.getcurrent()
> if not id is nothing then
> windows.Text = "WindowsIdentitly.GetCurrent(): " &
> id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
> id.AuthenticationType
> end if
>
> When I browse to this page it shows that the RS site IS authenticating
> my domain account [DOMAIN\username] but the authentication type is
> NTLM. On another server where I have RS working this same page shows
> Kerberos.
> I am at wits end. Thank you in advance for any help
> Scot
>|||On Oct 4, 3:56 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Check the IIS logs and see what the HTTP Code was for the image file
> access. That should help you start pinpointing where the authentication
> issue resides.
> Once you get those log entries you can post them here and I'll take a look
> and see if I can help.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: scot.hau...@.gmail.com
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Reporting Services IIS authentication
> > Date: Thu, 04 Oct 2007 12:53:54 -0700
> > Hi
> > SQL 2005 was first installed on a Win 2003 Server sans the Reporting
> > Services because IIS was not installed. Then we installed IIS and then
> > RS and then reapplied SP2 for SQL2005. RS runs under an appPool that
> > is configured with a local account that has admin priv. I log into an
> > AD domain account, my domain account is also in the local admins group
> > on this server.
> > On an XP client using IE I try to browse to the reports virtual
> > directory and am prompted for credentials. It looks like the web page
> > wants to display but the images are not shown. When I hit cancel in
> > the credentials box one of the missing images now displays the missing
> > image icon. I do this 5 or 6 times to get the credentials box to go
> > away. I am now looking at the Home page (with no images) It is almost
> > as if my account doesn't have permissions to read the image files even
> > though I am an admin on the machine. Note: I tried many username/
> > passwords in the credentials box including domain admins to no avail.
> > I don't get much farther than this, when I click on a link such as
> > Site Settings, sometimes it will take me to the page but most times it
> > will display the "You are not authorized to view this page" message.
> > [As an aside, a couple times after clicking cancel many times in
> > response to the credentials box it let me navigate all of the links
> > and displayed all of the images. When I would close the browser and
> > try again the credentials box issue was back. Getting it to work like
> > this is not repeatable]
> > I dropped an aspx page into the ReportManager folder (same one that
> > contains the Home.aspx) that contains this:
> > id=windowsidentity.getcurrent()
> > if not id is nothing then
> > windows.Text = "WindowsIdentitly.GetCurrent(): " &
> > id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
> > id.AuthenticationType
> > end if
> > When I browse to this page it shows that the RS site IS authenticating
> > my domain account [DOMAIN\username] but the authentication type is
> > NTLM. On another server where I have RS working this same page shows
> > Kerberos.
> > I am at wits end. Thank you in advance for any help
> > Scot- Hide quoted text -
> - Show quoted text -
Hi Chris
Here is my last session:
#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Date: 2007-10-04 20:17:53
#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query
s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-
status
2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 401 2 2148074254
2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
ItemPath=%2fData+Sources&ViewMode=List 80 GROUPO\scoth 10.100.100.217
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.
1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/js/
ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/styles/
ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
d=d_sKL_-f8zP8Xivl3WiIF2czKzMbiI3dePWfT02ysg81&t=633245900946638327 80
GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows
+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0
0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
+CLR+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/blank.gif
- 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 200 0 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 2148074241
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16newfolder.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16newdatasource.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16upload.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16newreport.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
+CLR+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
view_detail.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
toolbar_edge_bottom.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
+CLR+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16newfolder.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16newdatasource.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16upload.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16datasource.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
16newreport.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
+CLR+1.1.4322) 401 1 2148074241
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
Settings.aspx - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
Settings.aspx - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
Settings.aspx - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
Settings.aspx - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;
+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
+CLR+1.1.4322) 200 0 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/js/
ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/styles/
ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
d=d_sKL_-f8zP8Xivl3WiIF2czKzMbiI3dePWfT02ysg81&t=633245900946638327 80
GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows
+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0
0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/blank.gif
- 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 200 0 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 2148074241
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 2 2148074254
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
+1.1.4322) 401 1 0
2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
line_err1.gif - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;
+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
+CLR+1.1.4322) 200 0 0|||You are getting 401.1 errors on the image files for some reason. Try doing
this and see if it helps.
1. Open the SRS Configuration Tool.
2. Go to the Report Server and Report Manager virtual directory tabs and
check the "Apply Default Settings" check box
3. Click "Apply" on both of those pages to reset the VDIR settings.
4. Try it again.
5. If that doesn't work delete the Virtual Directories from IIS and then
use the configuration tool to recreate them from scratch.
6. If THAT doesn't work make sure that the local account that the app pool
is running under has file permissions to all of the files in the
ReportServer and ReportManager directories and their subdirectories.
Let me know if any of that works.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: scot.hauder@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services IIS authentication
> Date: Thu, 04 Oct 2007 14:37:29 -0700
> On Oct 4, 3:56 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Check the IIS logs and see what the HTTP Code was for the image file
> > access. That should help you start pinpointing where the authentication
> > issue resides.
> >
> > Once you get those log entries you can post them here and I'll take a
look
> > and see if I can help.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: scot.hau...@.gmail.com
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Reporting Services IIS authentication
> > > Date: Thu, 04 Oct 2007 12:53:54 -0700
> >
> > > Hi
> >
> > > SQL 2005 was first installed on a Win 2003 Server sans the Reporting
> > > Services because IIS was not installed. Then we installed IIS and then
> > > RS and then reapplied SP2 for SQL2005. RS runs under an appPool that
> > > is configured with a local account that has admin priv. I log into an
> > > AD domain account, my domain account is also in the local admins group
> > > on this server.
> >
> > > On an XP client using IE I try to browse to the reports virtual
> > > directory and am prompted for credentials. It looks like the web page
> > > wants to display but the images are not shown. When I hit cancel in
> > > the credentials box one of the missing images now displays the missing
> > > image icon. I do this 5 or 6 times to get the credentials box to go
> > > away. I am now looking at the Home page (with no images) It is almost
> > > as if my account doesn't have permissions to read the image files even
> > > though I am an admin on the machine. Note: I tried many username/
> > > passwords in the credentials box including domain admins to no avail.
> >
> > > I don't get much farther than this, when I click on a link such as
> > > Site Settings, sometimes it will take me to the page but most times it
> > > will display the "You are not authorized to view this page" message.
> > > [As an aside, a couple times after clicking cancel many times in
> > > response to the credentials box it let me navigate all of the links
> > > and displayed all of the images. When I would close the browser and
> > > try again the credentials box issue was back. Getting it to work like
> > > this is not repeatable]
> >
> > > I dropped an aspx page into the ReportManager folder (same one that
> > > contains the Home.aspx) that contains this:
> >
> > > id=windowsidentity.getcurrent()
> > > if not id is nothing then
> > > windows.Text = "WindowsIdentitly.GetCurrent(): " &
> > > id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
> > > id.AuthenticationType
> > > end if
> >
> > > When I browse to this page it shows that the RS site IS authenticating
> > > my domain account [DOMAIN\username] but the authentication type is
> > > NTLM. On another server where I have RS working this same page shows
> > > Kerberos.
> >
> > > I am at wits end. Thank you in advance for any help
> >
> > > Scot- Hide quoted text -
> >
> > - Show quoted text -
> Hi Chris
> Here is my last session:
> #Software: Microsoft Internet Information Services 6.0
> #Version: 1.0
> #Date: 2007-10-04 20:17:53
> #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query
> s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-
> status
> 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 401 2 2148074254
> 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> ItemPath=%2fData+Sources&ViewMode=List 80 GROUPO\scoth 10.100.100.217
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.
> 1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/js/
> ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/styles/
> ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
> d=d_sKL_-f8zP8Xivl3WiIF2czKzMbiI3dePWfT02ysg81&t=633245900946638327 80
> GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows
> +NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0
> 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
> +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> +CLR+1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/blank.gif
> - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 200 0 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 2148074241
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16newfolder.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16newdatasource.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16upload.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16newreport.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
> +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> +CLR+1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> view_detail.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> toolbar_edge_bottom.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
> +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> +CLR+1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16newfolder.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16newdatasource.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16upload.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16datasource.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> 16newreport.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
> +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> +CLR+1.1.4322) 401 1 2148074241
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
> Settings.aspx - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
> Settings.aspx - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
> Settings.aspx - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> 2007-10-04 20:30:36 W3SVC1 127.0.0.1 POST /ReportServer/
> ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/Pages/
> Settings.aspx - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;
> +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> +CLR+1.1.4322) 200 0 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/js/
> ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/styles/
> ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
> d=d_sKL_-f8zP8Xivl3WiIF2czKzMbiI3dePWfT02ysg81&t=633245900946638327 80
> GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows
> +NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0
> 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> 48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> 48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> 48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/blank.gif
> - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 200 0 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> 48settings.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 2148074241
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 2 2148074254
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> +1.1.4322) 401 1 0
> 2007-10-04 20:30:36 W3SVC1 10.100.10.37 GET /Reports/images/
> line_err1.gif - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;
> +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> +CLR+1.1.4322) 200 0 0
>|||On Oct 5, 8:44 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> You are getting 401.1 errors on the image files for some reason. Try doing
> this and see if it helps.
> 1. Open the SRS Configuration Tool.
> 2. Go to the Report Server and Report Manager virtual directory tabs and
> check the "Apply Default Settings" check box
> 3. Click "Apply" on both of those pages to reset the VDIR settings.
> 4. Try it again.
> 5. If that doesn't work delete the Virtual Directories from IIS and then
> use the configuration tool to recreate them from scratch.
> 6. If THAT doesn't work make sure that the local account that the app pool
> is running under has file permissions to all of the files in the
> ReportServer and ReportManager directories and their subdirectories.
> Let me know if any of that works.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no right=s=2E
> --
>
> > From: scot.hau...@.gmail.com
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: Reporting Services IIS authentication
> > Date: Thu, 04 Oct 2007 14:37:29 -0700
> > On Oct 4, 3:56 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > Check the IIS logs and see what the HTTP Code was for the image file
> > > access. That should help you start pinpointing where the authenticati=on
> > > issue resides.
> > > Once you get those log entries you can post them here and I'll take a
> look
> > > and see if I can help.
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > From: scot.hau...@.gmail.com
> > > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > > Subject: Reporting Services IIS authentication
> > > > Date: Thu, 04 Oct 2007 12:53:54 -0700
> > > > Hi
> > > > SQL 2005 was first installed on a Win 2003 Server sans the Reporting
> > > > Services because IIS was not installed. Then we installed IIS and t=hen
> > > > RS and then reapplied SP2 for SQL2005. RS runs under an appPool that
> > > > is configured with a local account that has admin priv. I log into =an
> > > > AD domain account, my domain account is also in the local admins gr=oup
> > > > on this server.
> > > > On an XP client using IE I try to browse to the reports virtual
> > > > directory and am prompted for credentials. It looks like the web pa=ge
> > > > wants to display but the images are not shown. When I hit cancel in
> > > > the credentials box one of the missing images now displays the miss=ing
> > > > image icon. I do this 5 or 6 times to get the credentials box to go
> > > > away. I am now looking at the Home page (with no images) It is almo=st
> > > > as if my account doesn't have permissions to read the image files e=ven
> > > > though I am an admin on the machine. Note: I tried many username/
> > > > passwords in the credentials box including domain admins to no avai=l=2E
> > > > I don't get much farther than this, when I click on a link such as
> > > > Site Settings, sometimes it will take me to the page but most times= it
> > > > will display the "You are not authorized to view this page" message.
> > > > [As an aside, a couple times after clicking cancel many times in
> > > > response to the credentials box it let me navigate all of the links
> > > > and displayed all of the images. When I would close the browser and
> > > > try again the credentials box issue was back. Getting it to work li=ke
> > > > this is not repeatable]
> > > > I dropped an aspx page into the ReportManager folder (same one that
> > > > contains the Home.aspx) that contains this:
> > > > id=3Dwindowsidentity.getcurrent()
> > > > if not id is nothing then
> > > > windows.Text =3D "WindowsIdentitly.GetCurrent(): " &
> > > > id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
> > > > id.AuthenticationType
> > > > end if
> > > > When I browse to this page it shows that the RS site IS authenticat=ing
> > > > my domain account [DOMAIN\username] but the authentication type is
> > > > NTLM. On another server where I have RS working this same page shows
> > > > Kerberos.
> > > > I am at wits end. Thank you in advance for any help
> > > > Scot- Hide quoted text -
> > > - Show quoted text -
> > Hi Chris
> > Here is my last session:
> > #Software: Microsoft Internet Information Services 6.0
> > #Version: 1.0
> > #Date: 2007-10-04 20:17:53
> > #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query
> > s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-
> > status
> > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 - 10.100.100.217 Mozilla/=4=2E0+
> > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > +2.0.50727;+.NET+CLR+1.1.4322) 401 2 2148074254
> > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 - 10.100.100.217 Mozilla/=4=2E0+
> > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 - 10.100.100.217 Mozilla/=4=2E0+
> > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> > 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 GROUPO\scoth 10.100.100.2=17
> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.
> > 1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/js/
> > ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/styles/
> > ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
> > d=3Dd_sKL_-f8zP8Xivl3WiIF2czKzMbiI3dePWfT02ysg81&t=3D633245900946638327= 80
> > GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows
> > +NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0
> > 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > +1.1.4322) 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > +1.1.4322) 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > +1.1.4322) 401 1 0
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > +1.1.4322) 401 2 2148074254
> > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
> > +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> ...
> read more =BB- Hide quoted text -
> - Show quoted text -
Hi Chris,
Thank you for looking into this. I have tried your suggestions twice
before initiating this thread. I don't know if this is unusual but
both of the times we installed RS we HAD to manually create the
virtual directories through the RS configuration utility--they were
not created during install. The apppool account is a member of the
local admin group as is my domain account. To add more confusion
consider this: I can log on locally to the server (using my same
domain account), go into IIS manager and under Default Web Site right
click the reports web app, click browse and everything looks ok, I can
even create a report that uses windows authentication to connect to a
remote SQL box. In addition I've added another user in RS and she can
browse the report site from her XP client without the credentials box
showing ! ... but when she tries to run the report I spoke of above,
the SQL connection fails because it is passing along NETWORK SERVICE\
ANNONYMOUS USER credentials. I can deal with this second hop issue
later but I can't figure out why this ordinary user doesn't have
problems browsing the site while myself and our domain admin are
prompted for credentials.
Scot|||Don't know if I asked this before but is the SRS server/web site in
"Trusted Sites" for you? If it is then Internet Explorer by default does
not do "Auto-Login" when a site is in that security group.
If you want to turn it on for Trusted Sites open up IE and do the following:
1. Open "Tools->Internet Options->Security Tab->Trusted Sites->Custom Level
button"
2. Go to the very last option in the list "User Authentication"
3. Check the "Automatic logon with current user name and password"
See if that helps.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: scot.hauder@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services IIS authentication
> Date: Fri, 05 Oct 2007 15:33:26 -0700
> On Oct 5, 8:44 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > You are getting 401.1 errors on the image files for some reason. Try
doing
> > this and see if it helps.
> >
> > 1. Open the SRS Configuration Tool.
> > 2. Go to the Report Server and Report Manager virtual directory tabs and
> > check the "Apply Default Settings" check box
> > 3. Click "Apply" on both of those pages to reset the VDIR settings.
> > 4. Try it again.
> > 5. If that doesn't work delete the Virtual Directories from IIS and then
> > use the configuration tool to recreate them from scratch.
> > 6. If THAT doesn't work make sure that the local account that the app
pool
> > is running under has file permissions to all of the files in the
> > ReportServer and ReportManager directories and their subdirectories.
> >
> > Let me know if any of that works.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > - Show quoted text -
> Hi Chris,
> Thank you for looking into this. I have tried your suggestions twice
> before initiating this thread. I don't know if this is unusual but
> both of the times we installed RS we HAD to manually create the
> virtual directories through the RS configuration utility--they were
> not created during install. The apppool account is a member of the
> local admin group as is my domain account. To add more confusion
> consider this: I can log on locally to the server (using my same
> domain account), go into IIS manager and under Default Web Site right
> click the reports web app, click browse and everything looks ok, I can
> even create a report that uses windows authentication to connect to a
> remote SQL box. In addition I've added another user in RS and she can
> browse the report site from her XP client without the credentials box
> showing ! ... but when she tries to run the report I spoke of above,
> the SQL connection fails because it is passing along NETWORK SERVICE\
> ANNONYMOUS USER credentials. I can deal with this second hop issue
> later but I can't figure out why this ordinary user doesn't have
> problems browsing the site while myself and our domain admin are
> prompted for credentials.
> Scot
>|||Another thing I forgot to mention is to check the "Unattended Execution
Account" you have configured in the SRS configuration tool.
Try removing/unsetting that account and then try it again that could be the
cause of your problems.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: scot.hauder@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services IIS authentication
> Date: Fri, 05 Oct 2007 15:33:26 -0700
> On Oct 5, 8:44 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > You are getting 401.1 errors on the image files for some reason. Try
doing
> > this and see if it helps.
> >
> > 1. Open the SRS Configuration Tool.
> > 2. Go to the Report Server and Report Manager virtual directory tabs and
> > check the "Apply Default Settings" check box
> > 3. Click "Apply" on both of those pages to reset the VDIR settings.
> > 4. Try it again.
> > 5. If that doesn't work delete the Virtual Directories from IIS and then
> > use the configuration tool to recreate them from scratch.
> > 6. If THAT doesn't work make sure that the local account that the app
pool
> > is running under has file permissions to all of the files in the
> > ReportServer and ReportManager directories and their subdirectories.
> >
> > Let me know if any of that works.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: scot.hau...@.gmail.com
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Re: Reporting Services IIS authentication
> > > Date: Thu, 04 Oct 2007 14:37:29 -0700
> >
> > > On Oct 4, 3:56 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > > wrote:
> > > > Check the IIS logs and see what the HTTP Code was for the image file
> > > > access. That should help you start pinpointing where the
authentication
> > > > issue resides.
> >
> > > > Once you get those log entries you can post them here and I'll take
a
> > look
> > > > and see if I can help.
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> >
> > > > > From: scot.hau...@.gmail.com
> > > > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > > > Subject: Reporting Services IIS authentication
> > > > > Date: Thu, 04 Oct 2007 12:53:54 -0700
> >
> > > > > Hi
> >
> > > > > SQL 2005 was first installed on a Win 2003 Server sans the
Reporting
> > > > > Services because IIS was not installed. Then we installed IIS and
then
> > > > > RS and then reapplied SP2 for SQL2005. RS runs under an appPool
that
> > > > > is configured with a local account that has admin priv. I log
into an
> > > > > AD domain account, my domain account is also in the local admins
group
> > > > > on this server.
> >
> > > > > On an XP client using IE I try to browse to the reports virtual
> > > > > directory and am prompted for credentials. It looks like the web
page
> > > > > wants to display but the images are not shown. When I hit cancel
in
> > > > > the credentials box one of the missing images now displays the
missing
> > > > > image icon. I do this 5 or 6 times to get the credentials box to
go
> > > > > away. I am now looking at the Home page (with no images) It is
almost
> > > > > as if my account doesn't have permissions to read the image files
even
> > > > > though I am an admin on the machine. Note: I tried many username/
> > > > > passwords in the credentials box including domain admins to no
avail.
> >
> > > > > I don't get much farther than this, when I click on a link such as
> > > > > Site Settings, sometimes it will take me to the page but most
times it
> > > > > will display the "You are not authorized to view this page"
message.
> > > > > [As an aside, a couple times after clicking cancel many times in
> > > > > response to the credentials box it let me navigate all of the
links
> > > > > and displayed all of the images. When I would close the browser
and
> > > > > try again the credentials box issue was back. Getting it to work
like
> > > > > this is not repeatable]
> >
> > > > > I dropped an aspx page into the ReportManager folder (same one
that
> > > > > contains the Home.aspx) that contains this:
> >
> > > > > id=windowsidentity.getcurrent()
> > > > > if not id is nothing then
> > > > > windows.Text = "WindowsIdentitly.GetCurrent(): " &
> > > > > id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
> > > > > id.AuthenticationType
> > > > > end if
> >
> > > > > When I browse to this page it shows that the RS site IS
authenticating
> > > > > my domain account [DOMAIN\username] but the authentication type is
> > > > > NTLM. On another server where I have RS working this same page
shows
> > > > > Kerberos.
> >
> > > > > I am at wits end. Thank you in advance for any help
> >
> > > > > Scot- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > Hi Chris
> > > Here is my last session:
> >
> > > #Software: Microsoft Internet Information Services 6.0
> > > #Version: 1.0
> > > #Date: 2007-10-04 20:17:53
> > > #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query
> > > s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus
sc-win32-
> > > status
> > > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > > ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217
Mozilla/4.0+
> > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > +2.0.50727;+.NET+CLR+1.1.4322) 401 2 2148074254
> > > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > > ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217
Mozilla/4.0+
> > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> > > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > > ItemPath=%2fData+Sources&ViewMode=List 80 - 10.100.100.217
Mozilla/4.0+
> > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> > > 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.aspx
> > > ItemPath=%2fData+Sources&ViewMode=List 80 GROUPO\scoth 10.100.100.217
> > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.
> > > 1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/js/
> > > ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/styles/
> > > ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
> > > d=d_sKL_-f8zP8Xivl3WiIF2czKzMbiI3dePWfT02ysg81&t=633245900946638327 80
> > > GROUPO\scoth 10.100.100.217 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows
> > > +NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0
> > > 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > > 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > > +1.1.4322) 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > > 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > > +1.1.4322) 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > > 48folderopen.jpg - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > > +1.1.4322) 401 1 0
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > > line_err1.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;+MSIE
> > > +6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET+CLR
> > > +1.1.4322) 401 2 2148074254
> > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/images/
> > > toolbar_edge_top.gif - 80 - 10.100.100.217 Mozilla/4.0+(compatible;
> > > +MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR+2.0.50727;+.NET
> >
> > ...
> >
> > read more »- Hide quoted text -
> >
> > - Show quoted text -
> Hi Chris,
> Thank you for looking into this. I have tried your suggestions twice
> before initiating this thread. I don't know if this is unusual but
> both of the times we installed RS we HAD to manually create the
> virtual directories through the RS configuration utility--they were
> not created during install. The apppool account is a member of the
> local admin group as is my domain account. To add more confusion
> consider this: I can log on locally to the server (using my same
> domain account), go into IIS manager and under Default Web Site right
> click the reports web app, click browse and everything looks ok, I can
> even create a report that uses windows authentication to connect to a
> remote SQL box. In addition I've added another user in RS and she can
> browse the report site from her XP client without the credentials box
> showing ! ... but when she tries to run the report I spoke of above,
> the SQL connection fails because it is passing along NETWORK SERVICE\
> ANNONYMOUS USER credentials. I can deal with this second hop issue
> later but I can't figure out why this ordinary user doesn't have
> problems browsing the site while myself and our domain admin are
> prompted for credentials.
> Scot
>|||On Oct 8, 8:52 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Another thing I forgot to mention is to check the "Unattended Execution
> Account" you have configured in the SRS configuration tool.
> Try removing/unsetting that account and then try it again that could be t=he
> cause of your problems.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no right=s=2E
> --
>
> > From: scot.hau...@.gmail.com
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: Reporting Services IIS authentication
> > Date: Fri, 05 Oct 2007 15:33:26 -0700
> > On Oct 5, 8:44 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > You are getting 401.1 errors on the image files for some reason. Try
> doing
> > > this and see if it helps.
> > > 1. Open the SRS Configuration Tool.
> > > 2. Go to the Report Server and Report Manager virtual directory tabs =and
> > > check the "Apply Default Settings" check box
> > > 3. Click "Apply" on both of those pages to reset the VDIR settings.
> > > 4. Try it again.
> > > 5. If that doesn't work delete the Virtual Directories from IIS and t=hen
> > > use the configuration tool to recreate them from scratch.
> > > 6. If THAT doesn't work make sure that the local account that the app
> pool
> > > is running under has file permissions to all of the files in the
> > > ReportServer and ReportManager directories and their subdirectories.
> > > Let me know if any of that works.
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > From: scot.hau...@.gmail.com
> > > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > > Subject: Re: Reporting Services IIS authentication
> > > > Date: Thu, 04 Oct 2007 14:37:29 -0700
> > > > On Oct 4, 3:56 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > > > wrote:
> > > > > Check the IIS logs and see what the HTTP Code was for the image f=ile
> > > > > access. That should help you start pinpointing where the
> authentication
> > > > > issue resides.
> > > > > Once you get those log entries you can post them here and I'll ta=ke
> a
> > > look
> > > > > and see if I can help.
> > > > > --
> > > > > Chris Alton, Microsoft Corp.
> > > > > SQL Server Developer Support Engineer
> > > > > This posting is provided "AS IS" with no warranties, and confers =no
> > > rights.
> > > > > --
> > > > > > From: scot.hau...@.gmail.com
> > > > > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > > > > Subject: Reporting Services IIS authentication
> > > > > > Date: Thu, 04 Oct 2007 12:53:54 -0700
> > > > > > Hi
> > > > > > SQL 2005 was first installed on a Win 2003 Server sans the
> Reporting
> > > > > > Services because IIS was not installed. Then we installed IIS a=nd
> then
> > > > > > RS and then reapplied SP2 for SQL2005. RS runs under an appPool
> that
> > > > > > is configured with a local account that has admin priv. I log
> into an
> > > > > > AD domain account, my domain account is also in the local admins
> group
> > > > > > on this server.
> > > > > > On an XP client using IE I try to browse to the reports virtual
> > > > > > directory and am prompted for credentials. It looks like the web
> page
> > > > > > wants to display but the images are not shown. When I hit cancel
> in
> > > > > > the credentials box one of the missing images now displays the
> missing
> > > > > > image icon. I do this 5 or 6 times to get the credentials box to
> go
> > > > > > away. I am now looking at the Home page (with no images) It is
> almost
> > > > > > as if my account doesn't have permissions to read the image fil=es
> even
> > > > > > though I am an admin on the machine. Note: I tried many usernam=e/
> > > > > > passwords in the credentials box including domain admins to no
> avail.
> > > > > > I don't get much farther than this, when I click on a link such= as
> > > > > > Site Settings, sometimes it will take me to the page but most
> times it
> > > > > > will display the "You are not authorized to view this page"
> message.
> > > > > > [As an aside, a couple times after clicking cancel many times in
> > > > > > response to the credentials box it let me navigate all of the
> links
> > > > > > and displayed all of the images. When I would close the browser
> and
> > > > > > try again the credentials box issue was back. Getting it to work
> like
> > > > > > this is not repeatable]
> > > > > > I dropped an aspx page into the ReportManager folder (same one
> that
> > > > > > contains the Home.aspx) that contains this:
> > > > > > id=3Dwindowsidentity.getcurrent()
> > > > > > if not id is nothing then
> > > > > > windows.Text =3D "WindowsIdentitly.GetCurrent(): =" &
> > > > > > id.Name & ", " & id.IsAuthenticated.ToString() & ", " &
> > > > > > id.AuthenticationType
> > > > > > end if
> > > > > > When I browse to this page it shows that the RS site IS
> authenticating
> > > > > > my domain account [DOMAIN\username] but the authentication type= is
> > > > > > NTLM. On another server where I have RS working this same page
> shows
> > > > > > Kerberos.
> > > > > > I am at wits end. Thank you in advance for any help
> > > > > > Scot- Hide quoted text -
> > > > > - Show quoted text -
> > > > Hi Chris
> > > > Here is my last session:
> > > > #Software: Microsoft Internet Information Services 6.0
> > > > #Version: 1.0
> > > > #Date: 2007-10-04 20:17:53
> > > > #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-que=ry
> > > > s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus
> sc-win32-
> > > > status
> > > > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.a=spx
> > > > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 - 10.100.100.217
> Mozilla/4.0+
> > > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > > +2.0.50727;+.NET+CLR+1.1.4322) 401 2 2148074254
> > > > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.a=spx
> > > > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 - 10.100.100.217
> Mozilla/4.0+
> > > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > > +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> > > > 2007-10-04 20:17:53 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.a=spx
> > > > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 - 10.100.100.217
> Mozilla/4.0+
> > > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > > +2.0.50727;+.NET+CLR+1.1.4322) 401 1 0
> > > > 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:06 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
> > > > 2007-10-04 20:18:16 W3SVC1 127.0.0.1 POST /ReportServer/
> > > > ReportService2005.asmx - 80 GROUPO\scoth 127.0.0.1 - 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/Pages/Folder.a=spx
> > > > ItemPath=3D%2fData+Sources&ViewMode=3DList 80 GROUPO\scoth 10.100.1=00.217
> > > > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.
> > > > 1;+.NET+CLR+2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/js/
> > > > ReportingServices.js - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> > > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > > +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/styles/
> > > > ReportingServices.css - 80 GROUPO\scoth 10.100.100.217 Mozilla/4.0+
> > > > (compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1;+.NET+CLR
> > > > +2.0.50727;+.NET+CLR+1.1.4322) 200 0 0
> > > > 2007-10-04 20:18:16 W3SVC1 10.100.10.37 GET /Reports/WebResource.axd
> ...
> read more =BB- Hide quoted text -
> - Show quoted text -
When trying to connect to the SRS in IE it shows local Intranet in the
status bar. The IE logon setting is set to: automatic logon only in
intranet zone...
The unattended execution account has never been set to anything|||Unfortunately I'm not sure what is causing your issue with the information
and time I have. You might try posting something in the IIS forums or if
you need to get the issue resolved immediately you can always open up a
support case with us.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: scot.hauder@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services IIS authentication
> Date: Tue, 09 Oct 2007 08:12:44 -0700
> On Oct 8, 8:52 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Another thing I forgot to mention is to check the "Unattended Execution
> > Account" you have configured in the SRS configuration tool.
> >
> > Try removing/unsetting that account and then try it again that could be
the
> > cause of your problems.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> >
> > - Show quoted text -
> When trying to connect to the SRS in IE it shows local Intranet in the
> status bar. The IE logon setting is set to: automatic logon only in
> intranet zone...
> The unattended execution account has never been set to anything
>|||On Oct 9, 11:43 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Unfortunately I'm not sure what is causing your issue with the information
> and time I have. You might try posting something in the IIS forums or if
> you need to get the issue resolved immediately you can always open up a
> support case with us.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: scot.hau...@.gmail.com
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re:ReportingServicesIISauthentication
> > Date: Tue, 09 Oct 2007 08:12:44 -0700
> > On Oct 8, 8:52 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > Another thing I forgot to mention is to check the "Unattended Execution
> > > Account" you have configured in the SRS configuration tool.
> > > Try removing/unsetting that account and then try it again that could be
> the
> > > cause of your problems.
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > - Show quoted text -
> > When trying to connect to the SRS in IE it shows local Intranet in the
> > status bar. The IE logon setting is set to: automatic logon only in
> > intranet zone...
> > The unattended execution account has never been set to anything- Hide quoted text -
> - Show quoted text -
Hi Chris,
This is 10 days old so you may not get back to this. Before I give my
solution I will let you know how frustrating this has been and thank
you for the time you have spent trouble shooting this. Like I said
before my account was in the local admin group and the appPool account
was a member of the admin group yet IIS still gave me problems. Worse
is sometimes the site would come up fine without prompting for
credentials and then the next hour or next day it would not work...
I'm sure many readers are going through this same scenario
Here is the solution:
1 Get Kerberos authentication working. The aspx page I threw into the
home directory said I was authenticating with NTLM. I had to change
the appPool account that the SSRS web apps was running under from a
local account to a domain account.
2 Run setspn for the appPool account name and the reporting server
setspn.exe -a http/IIS_computer's_NetBIOS_name DomainName
\AppPoolUserName
setspn.exe -a http/IIS_computer's_FQDN DomainName\AppPoolUserName
At this point I could browse the SSRS site fine but reports hitting
external db servers was not working (using Integrated Security=SSPI in
the report datasource) the "double hop" problem
3 In AD make sure the end users account does NOT have "Account is
sensitive and cannot be delegated" checked
4 In AD for the appPool account select Account is trusted for
delegation. Delegation for certain services only and Any
Authentication.
5 In IE Internet Options->Security Tab->Local intranet->User
Authentication Logon, make sure automatic logon in intranet zone is
selected
6 Go to the nearest bar and drink copiously
If anyone has read this far, I wish you luck
Cheers!
Scot