Reporting Services too slow.

Every time I log in for the first time in my Reporting Services by IIS it′s take forever.

Can I do something for increase the speed of this first connection to Reporting Services? After the first one the Reporting Services is much more faster.

Hello,

I believe the problem is your application pool is set to recycle too often. Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619105&SiteID=1

Hope this helps.

Jarret

|||Thanks... helped!

Reporting Services too slow.

Every time I log in for the first time in my Reporting Services by IIS it′s take forever.

Can I do something for increase the speed of this first connection to Reporting Services? After the first one the Reporting Services is much more faster.

Hello,

I believe the problem is your application pool is set to recycle too often. Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619105&SiteID=1

Hope this helps.

Jarret

|||Thanks... helped!

Reporting Services setup

I installed and started playing around with Reporting Services and realized that you are required to run IIS on your SQLserver in order to use RS. Is this 100% true?
Please tell me there is an alternative...this is huge roadblock due to company policy.

Thanks.Nevermind ...I found the answer here:MSDN library-Reporting Services

Reporting Services Reinstallation Problem

Somehow i messed up some IIS settings for Reporting Services and had to uninstall and reinstall Reporting Services. When reinstalling it, i get warnings about existing Report Server and tempReportServer database so i removed those 2 databases from SQL Server 2000. At the end of the installation, another warning popped up saying I need to initialize the report server manually. I ran rsconfig and rsactivate to initialize the report server. Now i get a no page found error when load http://localhost/reports. I can't seem to get any good documentation on the web for reporting services since it's fairly new. Please help.i can understand. its been a pain with the RS and no proper documentation so far. i've had to uninstall and reinstall the RS almost a dozen times one day in trying to get the forms authentication working. i dont know what problem you have but when u uninstall,
(1) delete the 2 databases from the sql server - reportserver and reportservertempdb
(2) are u using ssl ? if not you need to change the security level to 0. its 3 by default.
by default its in : C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder. in the RSReportServer file. theres a tag
<Add Key="SecureConnectionLevel" Value="3"/>. change the 3 to 0.

hth|||Thank for the reply. I did follow these 2 steps when reinstalling reporting services, but i still get the "setup could not initialize report server" message at the end of the installation process. Here's the log file hope someone can tell me what's wrong:

w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing InstanceName to default value of 'MSSQLSERVER.1' because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!87c!7/27/2004-10:45:32:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!ui!87c!7/27/2004-10:45:38:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!87c!7/27/2004-10:45:39:: e ERROR: HTTP status code --> 500
---Details---
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname)

at Microsoft.ReportingServices.UI.Global.SecureAllAPI()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!87c!7/27/2004-10:45:51:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!87c!7/27/2004-10:46:54:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!87c!7/27/2004-10:46:54:: e ERROR: HTTP status code --> 500
---Details---
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname)

at Microsoft.ReportingServices.UI.Global.SecureAllAPI()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!87c!7/27/2004-10:46:54:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)|||i cant make out where the problem is. check this site :http://hdconsultants.us/archive/2004/04/07/560.aspx

you can try these too :
1/ Start the Report Server Windows service if it is not already running. For more information, see "Starting and Stopping the Report Server Service" in Books Online.

2/ Click Start, click Run, type cmd in the text box, and then click OK.

3/ At the command prompt, type rsactivate -r. For more information, see "rsactivate Utility" in SQL Server 2005 Books Online.

4/ Restart IIS.

hth|||Still not working. After several times uninstalling and reinstalling it again, i'm now able to access the ReportServer folder, but everytime i try to access localhost/Reports (report manager) it gives me an error saying "The request failed with HTTP status 401: Unauthorized." I am still getting the "setup cannot initialize report server instance" warning after each installation. I am suspecting an IIS problem. Anyone else wanna try this one?

Reporting Services privileges

How do I need to setup IIS and SQL Server to get reporting services to work? When I navigate to http://<my server>/reports, I get a generic error page. PLease help!

More info: When I click "Set SharePoint administration group" from the SharePoint Central Administration page, I get the following:

"Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com"

The info in this KB article did not help.

Reporting Services is loosing stores credentials during connecting to Analysis Services

Hi, experts.
I have another strange problem with Reporting Services.
There are two machines:
-machine A with ReportingServices +IIS but without SQL SERVER nor
Analysis Services
-machine B with SQL Server and Reporting Services.
There is a web application in the machine A that collects data that
the web user
sends to the web server in order to pass it as parameters to Reporting
Services using a POST method. This POST method is sent from the
browsers (the web server
generates a form with hidden fields that are automatically sent to
Reporting Services by means of JavaScript).
Stored credentials are used in the datasource configuration and I've
put
all Services Packs that are available.
When the user wants to see the report for the first time, everything
works smoothly. Once it returns to the main page in order to visualize
other report or the same report once again, it is not possible to
connect to Reporting Services due to the security issues (dimension
not found error is obtained).
If I close the web browser and open it again, I can seee one report
and then
I obtain the same error.
I think that stored credentials are lost, but I have no idea how I can
fix it.
Thank you in advance for any ideas
Maciej Kiewrahmm...Are both your RS servers set up for Win Auth?
Depending on how your domain is configured, Windows credentials can be
passed across one computer connection before they expire. A user connection
to a report server counts as the first connection. If the user opens a
report that retrieves data from a remote server, that login counts as a
second connection and will fail if you are using Windows Authentication and
Kerberos is not enabled.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
--
Adrian M.
MCP
"Maciej Kiewra" <mkiewra@.mail.fujitsu.es> wrote in message
news:bc86bf57.0502221051.459d8e69@.posting.google.com...
> Hi, experts.
> I have another strange problem with Reporting Services.
> There are two machines:
> -machine A with ReportingServices +IIS but without SQL SERVER nor
> Analysis Services
> -machine B with SQL Server and Reporting Services.
>
> There is a web application in the machine A that collects data that
> the web user
> sends to the web server in order to pass it as parameters to Reporting
> Services using a POST method. This POST method is sent from the
> browsers (the web server
> generates a form with hidden fields that are automatically sent to
> Reporting Services by means of JavaScript).
> Stored credentials are used in the datasource configuration and I've
> put
> all Services Packs that are available.
> When the user wants to see the report for the first time, everything
> works smoothly. Once it returns to the main page in order to visualize
> other report or the same report once again, it is not possible to
> connect to Reporting Services due to the security issues (dimension
> not found error is obtained).
> If I close the web browser and open it again, I can seee one report
> and then
> I obtain the same error.
>
> I think that stored credentials are lost, but I have no idea how I can
> fix it.
> Thank you in advance for any ideas
> Maciej Kiewra|||Hi, experts
I´ve solved it. The problem was related with the user that
executed the web application ReportServer (IWAM anonymous access).
I´ve put a user that has access to Analysis Services in the anonymous
access option and now
everything works fine.
Regards
Maciej Kiewra
mkiewra@.mail.fujitsu.es (Maciej Kiewra) wrote in message news:<bc86bf57.0502221051.459d8e69@.posting.google.com>...
> Hi, experts.
> I have another strange problem with Reporting Services.
> There are two machines:
> -machine A with ReportingServices +IIS but without SQL SERVER nor
> Analysis Services
> -machine B with SQL Server and Reporting Services.
>
> There is a web application in the machine A that collects data that
> the web user
> sends to the web server in order to pass it as parameters to Reporting
> Services using a POST method. This POST method is sent from the
> browsers (the web server
> generates a form with hidden fields that are automatically sent to
> Reporting Services by means of JavaScript).
> Stored credentials are used in the datasource configuration and I've
> put
> all Services Packs that are available.
> When the user wants to see the report for the first time, everything
> works smoothly. Once it returns to the main page in order to visualize
> other report or the same report once again, it is not possible to
> connect to Reporting Services due to the security issues (dimension
> not found error is obtained).
> If I close the web browser and open it again, I can seee one report
> and then
> I obtain the same error.
>
> I think that stored credentials are lost, but I have no idea how I can
> fix it.
> Thank you in advance for any ideas
> Maciej Kiewra

Reporting services install question

I know ReportServer is a SQL Server service. Do I need SQL Server on the IIS
/ Report Server machine. What if I don't want to use a local SQL Server, but
I want to use a standalone SQL Server.
frankmReportServer is an asp.net application. It requires SQL Server as an object
store. SQL Server can be either on the same machine, on a different machine
or on a different machine shared by multiple Report Servers (web farm). Note
that for licensing you need to have a SQL Server license for the machine
Report Server is installed on regardless of whether SQL Server Database is
installed on it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"frankm" <frankm@.nospam.postalias> wrote in message
news:uYcsWjRwEHA.1148@.TK2MSFTNGP12.phx.gbl...
> I know ReportServer is a SQL Server service. Do I need SQL Server on the
IIS
> / Report Server machine. What if I don't want to use a local SQL Server,
but
> I want to use a standalone SQL Server.
> frankm
>|||Thank you -
That's what I needed to know. I can install RptSvc without having SQL Server
on the same machine. Just as long as I have a SQL Server somewhere for the
store.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23oIxUrRwEHA.3908@.TK2MSFTNGP12.phx.gbl...
> ReportServer is an asp.net application. It requires SQL Server as an
object
> store. SQL Server can be either on the same machine, on a different
machine
> or on a different machine shared by multiple Report Servers (web farm).
Note
> that for licensing you need to have a SQL Server license for the machine
> Report Server is installed on regardless of whether SQL Server Database is
> installed on it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:uYcsWjRwEHA.1148@.TK2MSFTNGP12.phx.gbl...
> > I know ReportServer is a SQL Server service. Do I need SQL Server on the
> IIS
> > / Report Server machine. What if I don't want to use a local SQL Server,
> but
> > I want to use a standalone SQL Server.
> >
> > frankm
> >
> >
>|||Bruce,
On the IIS server where RS will be installed, does SQL Server have to be
installed, or is there a way to just input the license number. Like most, we
run our SQL Server on a separate box than our IIS server. I do not want to
install SQL Server on the IIS box unless absolutely necessary.
Thanks
Dane Dickey
"Bruce L-C [MVP]" wrote:
> ReportServer is an asp.net application. It requires SQL Server as an object
> store. SQL Server can be either on the same machine, on a different machine
> or on a different machine shared by multiple Report Servers (web farm). Note
> that for licensing you need to have a SQL Server license for the machine
> Report Server is installed on regardless of whether SQL Server Database is
> installed on it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:uYcsWjRwEHA.1148@.TK2MSFTNGP12.phx.gbl...
> > I know ReportServer is a SQL Server service. Do I need SQL Server on the
> IIS
> > / Report Server machine. What if I don't want to use a local SQL Server,
> but
> > I want to use a standalone SQL Server.
> >
> > frankm
> >
> >
>
>

Reporting Services Install Error

I am tyring to install SQL 2000 Reporting services on a 2003 Server. I have
installed IIS, asp.net, VS .net 2003, etc. I installed service packs 3, and
4. I have not noticed the upgrade re: the versions. When I attempt to
install Reporting Services, I keep getting the error the the server requires
sp3a. I was able to install this on my laptop with minimal problems but I
cannot get it installed on my desktop. Please help.I found a solution. I had to install a new instance of the Desktop Engine.
Also, I had to install this from the command line as running the setup.exe
in GUI would not work. The following commands did the job:
setup SAPWD="AStrongSAPwd"
setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
I was able to setup Reporting Services following the installation of Service
Pack 3a.
"Che J" <crazybug212@.hotmail.com> wrote in message
news:OaF5JevRGHA.1204@.TK2MSFTNGP12.phx.gbl...
>I am tyring to install SQL 2000 Reporting services on a 2003 Server. I have
> installed IIS, asp.net, VS .net 2003, etc. I installed service packs 3,
> and
> 4. I have not noticed the upgrade re: the versions. When I attempt to
> install Reporting Services, I keep getting the error the the server
> requires
> sp3a. I was able to install this on my laptop with minimal problems but I
> cannot get it installed on my desktop. Please help.
>

Reporting Services IIS Installation error

I am trying to Install Reporting Services on a Production IIS 5.0 server and
I am getting the following error message:
Internet Information Services 5.0 (IIS) or later is either not installed, or
it is configured in a way that is incompatible with a Reporting Services
installation.
To install the Report Server and Report Manager components you must first
install Internet Information Services 5.0 (IIS) or later, and then verify
that the Web server configuration requirements are compatible with Setup.
Check the Setup documentation for more information about Web server
configuration requirements.
Report Designer component requirement.
I tested this installation twice in our test lab and it works fine, I can
see both Server and Client components but having problems in Prod. Any help
would be truly appreciated. Thanks in advance.Have you resolved this error? I seem to be having the same issue on WS2003...
"Waheed" wrote:
> I am trying to Install Reporting Services on a Production IIS 5.0 server and
> I am getting the following error message:
> Internet Information Services 5.0 (IIS) or later is either not installed, or
> it is configured in a way that is incompatible with a Reporting Services
> installation.
> To install the Report Server and Report Manager components you must first
> install Internet Information Services 5.0 (IIS) or later, and then verify
> that the Web server configuration requirements are compatible with Setup.
> Check the Setup documentation for more information about Web server
> configuration requirements.
> Report Designer component requirement.
> I tested this installation twice in our test lab and it works fine, I can
> see both Server and Client components but having problems in Prod. Any help
> would be truly appreciated. Thanks in advance.|||I'm having exactly the same problem... we already checked the IIS
configuration, and it all seems to be OK.
WS2003, SQL Server 2000, IIS 6... Reporting Services 2000 Developer
"Michael R" wrote:
> Have you resolved this error? I seem to be having the same issue on WS2003...
> "Waheed" wrote:
> > I am trying to Install Reporting Services on a Production IIS 5.0 server and
> > I am getting the following error message:
> >
> > Internet Information Services 5.0 (IIS) or later is either not installed, or
> > it is configured in a way that is incompatible with a Reporting Services
> > installation.
> > To install the Report Server and Report Manager components you must first
> > install Internet Information Services 5.0 (IIS) or later, and then verify
> > that the Web server configuration requirements are compatible with Setup.
> > Check the Setup documentation for more information about Web server
> > configuration requirements.
> > Report Designer component requirement.
> >
> > I tested this installation twice in our test lab and it works fine, I can
> > see both Server and Client components but having problems in Prod. Any help
> > would be truly appreciated. Thanks in advance.

Reporting Services IIS authentication

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