No item under Computer Management

Strange issue... I have a 2-node SQL Server 2000 Cluster with SP4
applied. Everything works fine but the Veritas BackupExec program can't
find the SQL Server. When I use Computer Management to connect to the
cluster by the cluster name (and also to the active node of the
cluster), I only found "no items" under Service and Applications -
Microsoft SQL Servers. Guess that is for the same reason that Veritas
can't see SQL Server.
Anyone has any idea what this is? Thanks a bunch!
You have to connect to the virtual SQL Server name, not the cluster name. I
prefer backing up directly to a disk share and then backing up those files
to tape for longer term archive. Veritas does not implement the full
restore functionality of SQL Server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"maoji" <mr.maoji@.gmail.com> wrote in message
news:1136980331.777473.245220@.o13g2000cwo.googlegr oups.com...
> Strange issue... I have a 2-node SQL Server 2000 Cluster with SP4
> applied. Everything works fine but the Veritas BackupExec program can't
> find the SQL Server. When I use Computer Management to connect to the
> cluster by the cluster name (and also to the active node of the
> cluster), I only found "no items" under Service and Applications -
> Microsoft SQL Servers. Guess that is for the same reason that Veritas
> can't see SQL Server.
> Anyone has any idea what this is? Thanks a bunch!
>
|||Thanks Geoff. Maybe I didn't make myself clear. I am connecting to the
SQL Server Cluster name instead of the Windows cluster name.
I've been using Veritas to backup our databases and I found it works ok
with me. Anyway, being not able to see the SQL resource in Computer
Management is weird, isn't it? There could be other problems in the
future. I just want to make sure this key database application works
all fine along the way.
Geoff N. Hiten wrote:[vbcol=seagreen]
> You have to connect to the virtual SQL Server name, not the cluster name. I
> prefer backing up directly to a disk share and then backing up those files
> to tape for longer term archive. Veritas does not implement the full
> restore functionality of SQL Server.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "maoji" <mr.maoji@.gmail.com> wrote in message
> news:1136980331.777473.245220@.o13g2000cwo.googlegr oups.com...
|||I just tried on two of our SQL Clusters and I connected to the controlling
node just fine. I was able to see Services and Applications just fine. Great
question, since I have not tried doing this before. I wonder if you don't
have a Group Policy Object blocking you or a firewall?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"maoji" <mr.maoji@.gmail.com> wrote in message
news:1136991184.533925.133310@.z14g2000cwz.googlegr oups.com...
> Thanks Geoff. Maybe I didn't make myself clear. I am connecting to the
> SQL Server Cluster name instead of the Windows cluster name.
> I've been using Veritas to backup our databases and I found it works ok
> with me. Anyway, being not able to see the SQL resource in Computer
> Management is weird, isn't it? There could be other problems in the
> future. I just want to make sure this key database application works
> all fine along the way.
>
> Geoff N. Hiten wrote:
>
|||Thanks everyone. It turns out to be all my fault.
After the successful setup of the SQL Cluster, I tried to rename the
SQL Cluster to another name in order to invisiblly replace another SQL
Server in our network. During that process I changed one of the
registry entries to use the new name, besides changing the SQL cluster
name in Cluster Administration console. And later on I found it was not
so easy as I thought and I changed the SQL server cluster name back in
the CA console, but forgot to change the registry back.
After changing the registry entry back everything is OK.
Thanks everyone! My bad, my bad. Have a good day!
Rodney R. Fournier [MVP] wrote:[vbcol=seagreen]
> I just tried on two of our SQL Clusters and I connected to the controlling
> node just fine. I was able to see Services and Applications just fine. Great
> question, since I have not tried doing this before. I wonder if you don't
> have a Group Policy Object blocking you or a firewall?
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> "maoji" <mr.maoji@.gmail.com> wrote in message
> news:1136991184.533925.133310@.z14g2000cwz.googlegr oups.com...
sql

No exception message from CLR stored procedure

Hello everybody,

I've encountered a strange thing using a CLR Stored procedure:

The procedure throws an exception with no message inside... value = {" "}

Basically the procedure has a string as argument which contains a SQL statement that changes according to the users selections...

The results of the query are saved into a dataset for further processing.

Those resultsets can sometimes be very big (ex: 15000 records...). (For the record the procedure works fine for smaller datasets ex 6000 records and running the same query on the application server returns the expected resultset )

By Debugging the procedure I could determine that the failing point was when the dataset is filled...

Anyone having any idea?

The only information I have from this exception is the stacktrace:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.CloseInternal(Boolean closeReader)

at System.Data.SqlClient.SqlDataReader.Close()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteScalar()

at DataAccess.runScalar(String strSQL, Boolean isStoredProcedure) in c:\Inetpub\wwwroot\Statistix\App_Code\DataAccess.cs:line 114

Thanks in advance

Alaindlk

Hello,

Still nobody having any idea of what is happening here?

Could it be possible that the SQL server is running out of memory or even having a connection timeout?

this is the procedure I've written that causes this behaviour:

[Microsoft.SqlServer.Server.SqlProcedure]

public static int Stats_Print_Data(string SqlQuery)

{

// Put your code here

int jobId = -1;

using (DataSet dsResults = new DataSet())

{

using (SqlConnection mConn = new SqlConnection("context connection = true"))

{

SqlCommand mCmd = new SqlCommand(SqlQuery, mConn);

mCmd.CommandTimeout = 100;

SqlDataAdapter mDa = new SqlDataAdapter(mCmd);

mDa.Fill(dsResults, "Print_Data");

if (dsResults.Tables[0].Rows.Count > 0)

{

ArrayList ColumnNames = new ArrayList();

for (int i = 8; i < dsResults.Tables[0].Columns.Count; i++)

{

DataColumn dc = dsResults.Tables[0].Columns;

ColumnNames.Add(dc.ColumnName);

}

StringBuilder InsertCommand = new StringBuilder();

StringBuilder Values = new StringBuilder();

try

{

mConn.Open();

mCmd.CommandText = "Select max(report_id) from Statistix_Report";

jobId = System.Convert.ToInt16(mCmd.ExecuteScalar());

jobId++;

foreach (DataRow dr in dsResults.Tables[0].Rows)

{

if (InsertCommand.Length > 0) InsertCommand.Remove(0, InsertCommand.Length);

if (Values.Length > 0) Values.Remove(0, Values.Length);

mCmd.CommandText = "Select count(*) from print_data where AG_LIB = '" + dr[2].ToString().Replace("'", "''") +

"' and AN_LIB = '" + dr[3].ToString().Replace("'", "''") + "' and PRD_LIB = '" + dr[4].ToString().Replace("'", "''") +

"' and TM_LIB = '" + dr[5].ToString().Replace("'", "''") + "' and RM_LIB = '" + dr.ToString().Replace("'", "''") +

"' and SU_LIB = '" + dr[7].ToString().Replace("'", "''") + "'";

if (System.Convert.ToInt16(mCmd.ExecuteScalar()) > 0)

{

InsertCommand.Append("Update PRINT_DATA set ");

for (int i = 0; i < ColumnNames.Count; i++)

{

InsertCommand.Append(ColumnNames + "_" + int.Parse(dr["Month"].ToString()) + " = ");

if (dr[i + 8] != DBNull.Value)

{

InsertCommand.Append(dr[i + 8].ToString().Replace(",", "."));

}

else

{

InsertCommand.Append("0");

}

if (i != ColumnNames.Count - 1)

{

InsertCommand.Append(",");

}

}

InsertCommand.Append(" where AG_LIB = '" + dr[2].ToString().Replace("'", "''"));

InsertCommand.Append("' and AN_LIB = '" + dr[3].ToString().Replace("'", "''") + "' and PRD_LIB = '" + dr[4].ToString().Replace("'", "''"));

InsertCommand.Append("' and TM_LIB = '" + dr[5].ToString().Replace("'", "''") + "' and RM_LIB = '" + dr.ToString().Replace("'", "''"));

InsertCommand.Append("' and SU_LIB = '" + dr[7].ToString().Replace("'", "''") + "' and JOB_ID = " + jobId);

mCmd.CommandText = InsertCommand.ToString();

mCmd.ExecuteNonQuery();

}

else

{

Values = new StringBuilder();

InsertCommand = new StringBuilder();

InsertCommand.Append("insert into print_data(AG_LIB,AN_LIB,PRD_LIB,TM_LIB,RM_LIB,SU_LIB,JOB_ID,");

Values.Append("'" + dr[2].ToString().Replace("'", "''") + "','" + dr[3].ToString().Replace("'", "''") + "','");

Values.Append(dr[4].ToString().Replace("'", "''") + "','" + dr[5].ToString().Replace("'", "''") + "','");

Values.Append(dr.ToString().Replace("'", "''") + "','" + dr[7].ToString().Replace("'", "''") + "'," + jobId + ",");

for (int i = 0; i < ColumnNames.Count; i++)

{

InsertCommand.Append(ColumnNames + "_" + int.Parse(dr["Month"].ToString()));

if (dr[i + 8] != DBNull.Value)

{

Values.Append(dr[i + 8].ToString().Replace(",", "."));

}

else Values.Append("0");

if (i != ColumnNames.Count - 1)

{

InsertCommand.Append(",");

Values.Append(",");

}

}

InsertCommand.Append(") values (");

InsertCommand.Append(Values.ToString() + ")");

mCmd.CommandText = InsertCommand.ToString();

mCmd.ExecuteNonQuery();

}

}

}

catch (Exception ex)

{

throw new Exception(InsertCommand.ToString(), ex);

}

finally

{

mCmd.Dispose();

mConn.Close();

}

}

}

}

return jobId;

}

Any help would be greatly appreciated...

How can i debug something like this?

Thanks in advance

|||

Are you sure that it is the error message thrown by SqlClient is empty and not the exception you throw here:

catch (Exception ex)

{

throw new Exception(InsertCommand.ToString(), ex);

}

? What happens if you remove this catch block and let the unhandled exception get propogated back to sql server - is it still empty?

|||

Hello Steven,

Thanks for your reply...

The exception I've given above is effectively thrown by the stored procedure...

Further investigation learned me that it was indeed a timeout of the stored procedure, so I deed improve the indexing on the tables which now solves partly my problem...

However The problem still remains as the stored procedure, after fetching the required data, saves this data into a table for reporting. The problem is that each 12 rows in the dataset has to be transformed as one record with 12 columns (Table sucks but I have to work with this solution imposed to me ) This means I first need to know if the record already exists, if not then create an insert statement else create an update statement.
Now it seems that executing this causes a timeout for the procedure.
Is there any way to increase this timeout period?

|||

Hello everybody,

I think I've finally found the reason why this timeout occurs: Thats because of the fact that the stored procedure returns a value...
In the worst case, my procedure takes about 10 minutes to complete.... letting the Application server waiting that long is "unacceptable". I think that SQL server automatically throws a timeout exception whenever a procedure/ function takes to long to complete.
I've solved this by changing the procedure signature from Static int SP_Name to static void SP_name(); This way the procedure doesn't have to return a value and isn't any more interrupted by a timeout thrown by SQL server...

Can anyone confirm me this behaviour of SQL server? (By the way this solution works fine for me now...)

Thanks in advance

No distinct in a select into stement ?

Dear MSSQL experts,

I use MSSQL 2000 and encountered a strange problem wqhile I tried to
use a select into statement .

If I perform the command command below I get only one dataset which has
the described properties.
If I use the same statement in a select into statement (see the second
select) I get several datasets with the described properties like I
didn't use distinct
Is there any posiibility to use destinct in a select into statement

select distinct IDENTITY (int) as ID, Title1 as Title1, Title2 as
Title2, Title3 as Title3,
AggregationTitle1 as AggregationTitle1, AggregationTitle2 as
AggregationTitle2,
AggregationTitle3 as AggregationTitle3, AggregationTitle4 as
AggregationTitle4
from Variables where Title1 is not NULL or Title2 is not NULL or
Title3 is not NULL or
AggregationTitle1 is not NULL or AggregationTitle2 is not NULL or
AggregationTitle3 is not NULL or AggregationTitle4 is not NULL;

This is the same with select into :

select distinct IDENTITY (int) as ID, Title1 as Title1, Title2 as
Title2, Title3 as Title3,
AggregationTitle1 as AggregationTitle1, AggregationTitle2 as
AggregationTitle2,
AggregationTitle3 as AggregationTitle3, AggregationTitle4 as
AggregationTitle4
into VarTitles from Variables where Title1 is not NULL or Title2 is
not NULL or Title3 is not NULL or
AggregationTitle1 is not NULL or AggregationTitle2 is not NULL or
AggregationTitle3 is not NULL or
AggregationTitle4 is not NULL;

Hope anyone can help.

Best regards,

Daniel Wetzler

IDaniel Wetzler wrote:
> Dear MSSQL experts,
> I use MSSQL 2000 and encountered a strange problem wqhile I tried to
> use a select into statement .
> If I perform the command command below I get only one dataset which has
> the described properties.
> If I use the same statement in a select into statement (see the second
> select) I get several datasets with the described properties like I
> didn't use distinct
> Is there any posiibility to use destinct in a select into statement
> select distinct IDENTITY (int) as ID, Title1 as Title1, Title2 as
> Title2, Title3 as Title3,
> AggregationTitle1 as AggregationTitle1, AggregationTitle2 as
> AggregationTitle2,
> AggregationTitle3 as AggregationTitle3, AggregationTitle4 as
> AggregationTitle4
> from Variables where Title1 is not NULL or Title2 is not NULL or
> Title3 is not NULL or
> AggregationTitle1 is not NULL or AggregationTitle2 is not NULL or
> AggregationTitle3 is not NULL or AggregationTitle4 is not NULL;
>
> This is the same with select into :
> select distinct IDENTITY (int) as ID, Title1 as Title1, Title2 as
> Title2, Title3 as Title3,
> AggregationTitle1 as AggregationTitle1, AggregationTitle2 as
> AggregationTitle2,
> AggregationTitle3 as AggregationTitle3, AggregationTitle4 as
> AggregationTitle4
> into VarTitles from Variables where Title1 is not NULL or Title2 is
> not NULL or Title3 is not NULL or
> AggregationTitle1 is not NULL or AggregationTitle2 is not NULL or
> AggregationTitle3 is not NULL or
> AggregationTitle4 is not NULL;
> Hope anyone can help.
> Best regards,
> Daniel Wetzler

The IDENTITY function makes each row unique so DISTINCT doesn't
eliminate the duplicates in this case. Interestingly, this behaviour
seems to have changed in SQL Server 2005. If I run your SELECT INTO on
2005 I get a different execution plan with the IDENTITY value computed
after DISTINCT.

For 2000 the workaround is easy. The following should insert just one
row into vartitles.

CREATE TABLE variables (title1 VARCHAR(10) NULL, title2 VARCHAR(10)
NULL, title3 VARCHAR(10) NULL, aggregationtitle1 VARCHAR(10) NULL,
aggregationtitle2 VARCHAR(10) NULL, aggregationtitle3 VARCHAR(10) NULL,
aggregationtitle4 VARCHAR(10) NULL);

INSERT INTO variables VALUES ('1','1','1','1','1','1','1');
INSERT INTO variables VALUES ('1','1','1','1','1','1','1');

SELECT IDENTITY (INT) AS id,
title1, title2, title3, aggregationtitle1, aggregationtitle2,
aggregationtitle3, aggregationtitle4
INTO VarTitles
FROM (
SELECT DISTINCT
title1, title2, title3, aggregationtitle1, aggregationtitle2,
aggregationtitle3, aggregationtitle4
FROM variables
WHERE title1 IS NOT NULL
OR title2 IS NOT NULL
OR title3 IS NOT NULL
OR aggregationtitle1 IS NOT NULL
OR aggregationtitle2 IS NOT NULL
OR aggregationtitle3 IS NOT NULL
OR aggregationtitle4 IS NOT NULL) AS V ;

SELECT * FROM vartitles ;

Hope this helps.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Thank you very much.
This was a very helpful hint.

Best regards,

Daniel|||Minor trick to make the code easier to read and maintain:

WHERE COALESCE (title1, title2, title3) IS NOT NULL
OR COALESCE (ggregation_title1, aggregation_title2,
aggregation_title3, aggregation_title4) IS NOT NULL

Unfortunately these columns look like repeated and a really bad 1NF
problem. I have the feeling that you might have wanted to use
COALESCE() in the SELECT list to get a non-null title and non-null
aggregation_title instead of this convoluted query.|||> Minor trick to make the code easier to read and maintain:
> WHERE COALESCE (title1, title2, title3) IS NOT NULL
> OR COALESCE (ggregation_title1, aggregation_title2,
> aggregation_title3, aggregation_title4) IS NOT NULL

and... bang goes performance too other than a probable clustered index scan
/ table scan.

Consider these two statements on my 800,000 row 834MByte message table for
the nntp forums...

There is a non-clustered index on nntp_author and there is non-clustered
index on author_id

-- Query 1
select count(*)
from mb_message_detail
where nntp_author is not null
or author_id is not null

-- Query 2
select count(*)
from mb_message_detail
where coalesce( nntp_author, author_id ) is not null

Query 1 will use the index author_id and give a half reasonable plan.
Query 2 will do a clustered index scan

Out of 100%, Query 1 is 12% and Query 2 is a whopping 88%

Seriously, go and get a junior job as a programmer and get some very needed
industrial / real world experience instead of bashing people down on here,
as far as 'newbie' goes - you have room to talk.....

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1145969845.021110.74070@.t31g2000cwb.googlegro ups.com...
> Minor trick to make the code easier to read and maintain:
> WHERE COALESCE (title1, title2, title3) IS NOT NULL
> OR COALESCE (ggregation_title1, aggregation_title2,
> aggregation_title3, aggregation_title4) IS NOT NULL
> Unfortunately these columns look like repeated and a really bad 1NF
> problem. I have the feeling that you might have wanted to use
> COALESCE() in the SELECT list to get a non-null title and non-null
> aggregation_title instead of this convoluted query.|||-------
Seriously, go and get a junior job as a programmer and get some very
needed
industrial / real world experience instead of bashing people down on
here,
as far as 'newbie' goes - you have room to talk.....
-------

<BIG GRIN> from on who has been the receiving side of one of CELKO's
many put-downs.

No Data Needed To be Merged - But Only for INSERT ??

Hi All,
I'm receiving some strange behaviour from replication between SQL Server 2K/SQL CE.
Replicating UPDATE's to a table on my server works fine as viewed in the Replication
Monitor and the updated rows in the table.
However, if I replicate INSERTS, then Replication Monitor reports No Data Needed
To be Merged and the rows are not inserted in the table.
Has anyone come across this issue?
Cheers,
ciaran
Does your Table use Identity Values ?
If so, then you will need to set it to (Not For Replication).
|||Hi Gerry,
My table does use Identity Values, and it does have NOT FOR Replication set.
I also have Identity Ranges set.
Some more info. that has just come to light. Some rows DO insert, while other
rows do not. At one stage the SQL CE database that was on the devices was
physically deleted and re-initialised. Could it be that the old rows were left
lying around and that somehow this is preventing me from doing my inserts on
these rows? In which case what can I do? Delete rows from MSmerge_contents?
Thanks for the help !
|||By re-initialised do you mean you re-initialised the Subscription (i.e. under Replication Monitor / Publishers / right click on the publication and selected Reinitialise All Subscriptions ?)
Try running the option (again right click on the Publisher) and selet Validate all Subscriptions to see if
the subscriber is in sync with the publisher.
Check out BOL "Validating Replicatated Data" for more info on this.
sql

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