Metadata Services: report

Showing posts with label report. Show all posts

Friday, March 30, 2012

No mapping between account names and security IDs was done

I can design a report fine in the Report Designer. I can build it fine. I can preview it fine. But, when I try to deploy it I get the error: No mapping between account names and security IDs was done

Any help will be appreciated.

Glenn,

Did you get past this error? I'm having the same issue now with my SQL Server Reporting Services / Report

No mapping between account names and security IDs was done

I can design a report fine in the Report Designer. I can build it fine. I can preview it fine. But, when I try to deploy it I get the error: No mapping between account names and security IDs was done

Any help will be appreciated.

Glenn,

Did you get past this error? I'm having the same issue now with my SQL Server Reporting Services / Report

No longer emailing

Hi all,
On Thursday, the reports scheduled to be emailed suddenly stooped being
sent. When I go into the report, it shows an error as follows:
Failure sending mail: The message could not be sent to the SMTP server.
The transport error code was 0x800ccc15. The server response was not
available
Can anybody tell me what this means?
Many ThanksThere is some error with your SMTP server. You should contact the owner of
this server to see if it is still up and responding.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JaffaB" <jaffa_brown@.yahoo.co.uk> wrote in message
news:1133699800.462800.168610@.g44g2000cwa.googlegroups.com...
> Hi all,
> On Thursday, the reports scheduled to be emailed suddenly stooped being
> sent. When I go into the report, it shows an error as follows:
> Failure sending mail: The message could not be sent to the SMTP server.
> The transport error code was 0x800ccc15. The server response was not
> available
> Can anybody tell me what this means?
> Many Thanks
>|||JaffaB, good morning!
Did you find the solution to your question below? If so, could you please
share with me what you did to resolve it?
Thank you.
"JaffaB" wrote:
> Hi all,
> On Thursday, the reports scheduled to be emailed suddenly stooped being
> sent. When I go into the report, it shows an error as follows:
> Failure sending mail: The message could not be sent to the SMTP server.
> The transport error code was 0x800ccc15. The server response was not
> available
> Can anybody tell me what this means?
> Many Thanks
>

Wednesday, March 28, 2012

No HTML page breaks and slow expanding rows

I have a report with a single table, single grouping level, single data set and no sub-reports. It has 3 rows for a grouping header and 3 rows per dataset row of detail. The detail rows are initially hidden and can be expanded by clicking on the header +. Its a fairly standard master-detail report.

Regardless of data size, I get NO page breaks in HTML. I have the Interactive size set to 8.5x11, KeepTogether is set to False, and PageBreakAtEnd is set to False. I would like it to break based on the visible grouping rows.

As it is now, everytime you expand any section, it takes forever to reload for a larger recordset.

I know that "HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.", but how do I get this report to page break? I've seen a lot of posts on this, but none that seem to have an answer.

Anyone? Can I programmatically add the soft page breaks? The report is useless as it is now.|||

Thanks to others, I found a solution. Use the query to calculate the count of headers using the dense_rank() function:

select ...

dense_rank() over ( order by cl.last_name, cl.first_name, cl.client_id ) AS ClientRank

Then add a top level grouping on the table set to "Page Break at End" with the formula:

=Ceiling(Fields!ClientRank.Value/15)

replace 15 with how many group headers you want per page.

-Dave

sql

No Error but Export to Excel does not finish

When the report has 2 pages with total 500 rows exporting to Excel is not a problem.

If it has 100 pages 5000 rows exporting to excel does not end and it does not return any error but the process does not end either. What might the problem be?

How you are exporting?

Are you using SSIS or DTS package?

I don't see any relation between reporting services & export to excel or are you trying to save as EXCEL spreadsheet.

|||

In there report manager, I run the report and then choose excel and export.

|||

Try increasing the value of MemoryLimit in the RSReportServer.config file available under Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder. The default value is 60, try increasing to a higher value but keep it under 120.

Shyam

sql

Monday, March 26, 2012

No Email

Hello.
I have created a domain account, granted the account Administrator access on
the report server machine, have changed the two windows services to run as
that account, and have created an Exchange mailbox for the domain account.
I created a simple report that has no data source. I created a shared
calendar that runs every 1 minute. I subscribed to the report on that
schedule, no report.
The report is not being emailed.
Any thoughts?
Thanks in advance,
MikeAlso, SQL server instance is on a different machine.
I don't think that the report is even running. Does reporting services use
the SQL agent?
"mike" <milop@.slomins.com> wrote in message
news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hello.
> I have created a domain account, granted the account Administrator access
> on the report server machine, have changed the two windows services to run
> as that account, and have created an Exchange mailbox for the domain
> account.
> I created a simple report that has no data source. I created a shared
> calendar that runs every 1 minute. I subscribed to the report on that
> schedule, no report.
> The report is not being emailed.
> Any thoughts?
> Thanks in advance,
> Mike
>|||No,Mike it does not.
"mike" wrote:
> Also, SQL server instance is on a different machine.
> I don't think that the report is even running. Does reporting services use
> the SQL agent?
> "mike" <milop@.slomins.com> wrote in message
> news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > Hello.
> >
> > I have created a domain account, granted the account Administrator access
> > on the report server machine, have changed the two windows services to run
> > as that account, and have created an Exchange mailbox for the domain
> > account.
> >
> > I created a simple report that has no data source. I created a shared
> > calendar that runs every 1 minute. I subscribed to the report on that
> > schedule, no report.
> >
> > The report is not being emailed.
> >
> > Any thoughts?
> >
> > Thanks in advance,
> >
> > Mike
> >
>
>|||As Per my knowledge an SQL Agent job is created for each schedule. SQL Server
Agent is very much required to run the Scheduled SRS Reports.
Ashish
"ProJester" wrote:
> No,Mike it does not.
>
> "mike" wrote:
> > Also, SQL server instance is on a different machine.
> >
> > I don't think that the report is even running. Does reporting services use
> > the SQL agent?
> >
> > "mike" <milop@.slomins.com> wrote in message
> > news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > > Hello.
> > >
> > > I have created a domain account, granted the account Administrator access
> > > on the report server machine, have changed the two windows services to run
> > > as that account, and have created an Exchange mailbox for the domain
> > > account.
> > >
> > > I created a simple report that has no data source. I created a shared
> > > calendar that runs every 1 minute. I subscribed to the report on that
> > > schedule, no report.
> > >
> > > The report is not being emailed.
> > >
> > > Any thoughts?
> > >
> > > Thanks in advance,
> > >
> > > Mike
> > >
> >
> >
> >sql

No Data-Driven Subscription button

I have created a report and published it on the reporting server. My connection is working, and I have followed the steps in the BOL tutorial for "Defining a Data-Driven Subscription" i.e. Credentials stored securely on report server, using windows credentials when connecting to the data source. When I click on "Subscriptions", I only see "New Subscriptions". However, when I look at other reports (not even created by me), I see the option to create data driven subscriptions. Can somebody tell me what I need to do to see this?I got it; the report cannot be in the "My Reports" folder.

No data to print

Hello Guys,
I am having hard time printing "No data to print" when there are no records returned by the report. Rightnow report prints without data but with all column headings. I would appreciate hearing from you soon.
Thanks
Dilemma

:wave:Hi,
In all headers suppress events write the formula as below
if isnull({DatabaseFeild}) =True then True
Place a new header in the header showing the value "No data to Print"
Now in the suppress event of this header write the formula as
if isnull({DatabaseFeild}) =false then True
Madhivanan|||Hello Madhi,

Thanks for the reply. I appreciate your help.

I am just wondering how do u write code header supress event. Do u have to write some code in your eg. VB or PB's event or in crystal report designer itself ? Unfortunately I am using PowreBuilder (pb) for the development.

Thanks
Dilemma|||Hi,
You can use this code in the crystal report itself.
Right click on header and select format section. A pop up menu will appear. There will be a check box labelled as Suppress. In parallel to that a button labelled X-2 is there. Click that button and write the coding I have mentioned. You have to this process for each header. To display "No data to Print", just add a text object and write it as "No data to Print" and in the suppress option write the second formula.

Madhivanan

No Data Returned for report

Hi,

In RS 2005, if a specific query does not return any rows, the table also is not displayed in the report.

Is there any way to get around this and show an empty table?

Manish

Hi,

select all the cells and in the properties make "borderstyle" - "Solid"

and select the table and make same as above in the properties.

you can see the empty table.

Amarnath

|||

One option is to set the "NoRows" property of the table. You can also apply styles to that message.

-- Robert

|||

This is correct but only if the table has a Header or Footer row.

If the dataset associated with a table returns no data, and there is no "NoRows" message specified for the table, AND if there is a header or footer, the table will be shown.

-chris

No data retuned

Hi,
Does anyone know of a way to show a user that there is no data returned into a report from a query, I am using ASP.NET with reportviewer and if the report does not return data I want to tell the user and not let them wait for no response. Is there a method or property within crystal that I can use?CrystalViewer control provides two functions called GetCurrentPageNumber() and ShowFirstPage(). Using these two functions you could move your cursor to page 1 and then try getting Getcurrentpagenumber or either call GetCurrentPageNumber which if returns 0 then there is no data else there is a data.

Thanks

No data is displayed in a Report on Win98

Hi,

I have created an OCX control in VB6.0 that contains the crystal report viewer.

On development machine (i.e. Win2K), my OCX control shows the crystal report properly. But, when I install my application on the client machine (Win98) no data is displayed in the report.

I have created the report using ADO connection and I am using 'SetDataSource' method of report object to pass the recordset to the report.

I have installed Crystal Report Application on the client machine. Through crystal report application I could see the data in the report.

Can any one help me?

With regards,
PinakinI use CrystalRyport. I want to print records in the same line in succession, how do i do

Friday, March 23, 2012

no data handling

I have created a sales checking report which will only show the items below
the sales target, now I subcribe this report by email daily basis, but even
there are no any data on the report, it will also sumbit a blank report to
me. it is possbile to control no data handling for reporting or subcription.
Thanks for any suggestions.On Jul 7, 5:28 am, "Sampras" <sampras...@.hotmail.com> wrote:
> I have created a sales checking report which will only show the items below
> the sales target, now I subcribe this report by email daily basis, but even
> there are no any data on the report, it will also sumbit a blank report to
> me. it is possbile to control no data handling for reporting or subcription.
> Thanks for any suggestions.
As far as I know, through the Report Manager there is not. In order to
have this kind of flexibility, you would most likely need to create a
custom ASP.NET/Winforms application called via a scheduled task, etc.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

No cubes can be found error

In the data panel of the report designer component, every time I try to create or modify an MDX statement, I'm now getting a "No cubes can be found. (Microsoft.AnalysisServices.Controls)" error. Works fine on the Layout and Preview tabs. Just all of a sudden appeared. Working fine against relational sources. As a warning to all, Reporting Services and Analysis Services is definitely not a marriage made in heaven. Proceed with caution.I'm going to have to learn to delete my profile everytime something strange happens with SQL 2005. Somehow, my profile on my primary development machine was corrupted again.

No CSS property for textbox?

We want to use our styles say "mystyle" on a report. I am surprised that we do not have cssstylename as a property for a textbox?

Ideally, i should be able to add that style in the styles.css file and reference the style name on the textbox. All that would be needed is that it would add an attribute to the rendered html. I wonder if it already exists and i am missing some information?

CSS is not supported in the current version. Hopefully it will be there in the future

Wednesday, March 21, 2012

no border

when i print my report i do not want to have border

how do i do?

Thanks

nobody

|||

This is not a chat ;)

What about going to report properties (Report -> Report properties) and setting the left/right/bottom/top border to 0?

|||

i did try before i post my question here and for some reason its not allowing you to put 0 in the border

you get error when you try to put 0

|||

what borders do you mean?
the border around an element (e.g. a black line), or the white border of the report on the printed page(called margin I think)?

In the report-properties you can set the margin to 0, but you cant set a element-border to 0 to do so you have to set border-style to none..

Best regards
Benjamin

No BI Dev Studio after install of Dev edition

I recently installed the Developerâ's edition of SQL Server 2005 so I could
check out the report builder.
After installing on a XP Pro workstation, I looked and it doesnâ't appear to
have installed the Business Intelligence Developer Studio.
Is this not included in the Dev Edition?
Thanks in advance.Are you sure that you selected the option to install workstation components,
books online and development tools. If you did not, BIDS will not be
installed.
Ed.
"rstevens" <rstevens@.discussions.microsoft.com> wrote in message
news:DDE881F0-1682-4B8C-B349-C99EAC4B7D02@.microsoft.com...
>I recently installed the Developer's edition of SQL Server 2005 so I could
> check out the report builder.
> After installing on a XP Pro workstation, I looked and it doesn't appear
> to
> have installed the Business Intelligence Developer Studio.
> Is this not included in the Dev Edition?
> Thanks in advance.
>|||I could have sworn that I told it to install the dev tools, but apparently
hadn't.
Thanks, that was it.
"Ed Allison" wrote:
> Are you sure that you selected the option to install workstation components,
> books online and development tools. If you did not, BIDS will not be
> installed.
> Ed.
> "rstevens" <rstevens@.discussions.microsoft.com> wrote in message
> news:DDE881F0-1682-4B8C-B349-C99EAC4B7D02@.microsoft.com...
> >I recently installed the Developer's edition of SQL Server 2005 so I could
> > check out the report builder.
> >
> > After installing on a XP Pro workstation, I looked and it doesn't appear
> > to
> > have installed the Business Intelligence Developer Studio.
> >
> > Is this not included in the Dev Edition?
> >
> > Thanks in advance.
> >
>
>

No available values in Report Builder parameter

In a Report builder report I have runtime prompt filter on a field.
But I am not able to see the available values in the dropdown for this field.
My filter is on a "New Field" with the formula :
IF(LENGTH(FieldName)>0,FieldName,("Blank"))

However if my filter is on the FieldName directly and not on the New Field with the above formula I do get the available values.
Is there any way I can get the available values in a dropdown for the New Field?

In Model Designer, add the "New Field" formula as a new attribute to the entity. Then set ValueSelection of the attribute to be dropdown.|||

True any field which is present in the Model can be shown in the dropdown.

I was exploring if a new formula field that is not actually present in the model, might also have 'Available values'.Thanks for your response.

sql

No available values in Report Builder parameter

In Model Designer, add the "New Field" formula as a new attribute to the entity. Then set ValueSelection of the attribute to be dropdown.|||

True any field which is present in the Model can be shown in the dropdown.

I was exploring if a new formula field that is not actually present in the model, might also have 'Available values'.Thanks for your response.

No authentication prompt when running report

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

Friday, March 30, 2012

No mapping between account names and security IDs was done

No mapping between account names and security IDs was done

No longer emailing

Wednesday, March 28, 2012

No HTML page breaks and slow expanding rows

No Error but Export to Excel does not finish

Monday, March 26, 2012

No Email

No Data-Driven Subscription button

No data to print

No Data Returned for report

No data retuned

No data is displayed in a Report on Win98

Friday, March 23, 2012

no data handling

No cubes can be found error

No CSS property for textbox?

Wednesday, March 21, 2012

no border

No BI Dev Studio after install of Dev edition

No available values in Report Builder parameter

No available values in Report Builder parameter

No authentication prompt when running report

Metadata Services

Blog Archive

About Me