Groups | Blog | Home
all groups > sql server reporting services > march 2005 >

sql server reporting services : HTTP Error message


Adrian M.
3/1/2005 4:37:22 PM
What if anything do you get in the log files?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_1m61.asp


--
Adrian M.
MCP

[quoted text, click to view]

Sean Deegan
3/1/2005 9:13:45 PM
Hello all,

I have been running an MS RS for about 6 months now with no real issues. I
actually really enjoy the product. However, I've recently had something
crop up that I just can't seem to solve (and so it's likely something really
quite obvious).

I can no longer access my reports from outside of my network. This didn't
used to be a problem. I'm using DDNS so that my users can get to the
reports from anywhere (I've got a really small company, so it's pretty easy
to manage). However, now I can get to the list of reports, but as soon as I
try to run one, I get an error "The page cannot be displayed". No
permissions error, nothing obvious that I can see, I've searched google
(probably didn't put the right combo of words in), microsoft etc...to no
avail. This was working, what did I do to break it?

Any suggestions would be welcome, or if you need more information, please
feel free to contact me.

Regards,
Sean

Sean Deegan
3/1/2005 9:44:44 PM
Adrian,

Thanks for taking a look at this. I think it's a permissions thing... but
any input you have would be welcome. See below for logfile:

<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>f:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__03_01_2005_16_36_31.log</Path>
<SystemName>SRCFILESERVER</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!fc0!3/1/2005-16:36:31:: i INFO: Reporting Web Server started
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing PollingInterval to
'10' second(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing MaximumMemoryLimit
to '80' percent as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing MaxQueueThreads to
'0' thread(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing MaxScheduleWait to
'5' second(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing RunningRequestsAge
to '30' second(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!fc0!3/1/2005-16:36:31:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.
w3wp!resourceutilities!fc0!3/1/2005-16:36:31:: i INFO: Running on 1 physical
processors, 1 logical processors
w3wp!resourceutilities!fc0!3/1/2005-16:36:31:: i INFO: Reporting Services
starting SKU: Standard
w3wp!runningjobs!fc0!3/1/2005-16:36:31:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!fc0!3/1/2005-16:36:31:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!fc0!3/1/2005-16:36:31:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!fc0!3/1/2005-16:36:31:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!ee0!03/01/2005-16:36:44:: i INFO: Call to
GetPermissions:/srcOnlineReports
w3wp!crypto!ee0!03/01/2005-16:36:44:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!ee0!03/01/2005-16:36:44:: i INFO: Exporting public key
w3wp!crypto!ee0!03/01/2005-16:36:44:: i INFO: Performing sku validation
w3wp!crypto!ee0!03/01/2005-16:36:44:: i INFO: Importing existing encryption
key
w3wp!library!fc0!03/01/2005-16:36:56:: i INFO: Call to GetSystemPermissions
w3wp!library!1170!03/01/2005-16:37:02:: i INFO: Call to GetPermissions:/
w3wp!library!1170!03/01/2005-16:37:02:: i INFO: Call to GetSystemPermissions
w3wp!library!1170!03/01/2005-16:37:10:: i INFO: Call to
GetPermissions:/srcOnlineReports
w3wp!library!1170!03/01/2005-16:37:20:: i INFO: Call to GetSystemPermissions
w3wp!library!1170!03/01/2005-16:39:09:: i INFO: Call to GetPermissions:/
w3wp!library!1170!03/01/2005-16:39:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1170!03/01/2005-16:39:18:: i INFO: Call to
GetPermissions:/srcOnlineReports
w3wp!library!1170!03/01/2005-16:39:18:: i INFO: Call to GetSystemPermissions
w3wp!library!1170!03/01/2005-16:39:25:: i INFO: Call to
GetPermissions:/srcOnlineReports/Membership Count Chart
w3wp!library!1170!03/01/2005-16:39:25:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!1170!03/01/2005-16:39:25:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was not
specified in Server system properties.
w3wp!library!fc0!03/01/2005-16:39:26:: i INFO: Call to GetSystemPermissions
w3wp!library!fc0!03/01/2005-16:42:29:: i INFO: Call to GetPermissions:/
w3wp!library!fc0!03/01/2005-16:42:29:: i INFO: Call to GetSystemPermissions
w3wp!library!fc0!03/01/2005-16:42:52:: i INFO: Call to
GetPermissions:/srcOnlineReports
w3wp!library!fc0!03/01/2005-16:42:52:: i INFO: Call to GetSystemPermissions
w3wp!library!fc0!03/01/2005-16:42:57:: i INFO: Call to
GetPermissions:/srcOnlineReports/Membership Count Chart
w3wp!library!fc0!03/01/2005-16:42:58:: i INFO: Call to GetSystemPermissions


[quoted text, click to view]
Jeff Pittenger
3/3/2005 5:55:16 PM
I am having the exact same problem.
There are no errors in my reporting services logs.
Users outside the firewall are asked to authenticate to the RS server.
After authenticating we can see the lists of reports.
But cannot access any of the reports themselves.

Jeff

[quoted text, click to view]

Jeff Pittenger
3/4/2005 10:07:58 AM
Yes the webaddress is different.
I do not really want to use the internal address on the outside world it is
not a logical name.
I cannot ping the server because it sits behind the firewall on my internal
network.
No hosts entries.
any ideas on how this can/should be done?

Jeff

[quoted text, click to view]

Jeff Pittenger
3/4/2005 10:42:40 AM
The link uses the NATed IP address of the RS server in the URL so would DNS
make a difference?
(ie. 12.158.nnn.nnn/Reports/Pages/reports.aspx.......)
I am asked to authenticate and can authenticate successfully.
I get all the way to the point where I choose a report and then get the Page
cannot be displayed error but only on the view tab.
for example I have access to the properties tab for the same report.

here are the report server log excerpts showing the difference between a
successful (internal) and failed report generation.

INTERNAL NETWORK - Successful
aspnet_wp!library!117c!03/04/2005-10:14:34:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!117c!03/04/2005-10:14:34:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1310!03/04/2005-10:14:36:: i INFO: Call to
GetPermissions:/Management
aspnet_wp!library!1310!03/04/2005-10:14:36:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!f04!03/04/2005-10:14:39:: i INFO: Call to
GetPermissions:/Management/Monthly Comparison Report
aspnet_wp!library!f04!03/04/2005-10:14:40:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1310!03/04/2005-10:14:40:: i INFO: Call to RenderFirst(
'/Management/Monthly Comparison Report' )
aspnet_wp!library!1310!03/04/2005-10:14:41:: i INFO: Initializing
EnableExecutionLogging to 'False' as specified in Server system properties.
aspnet_wp!webserver!1310!03/04/2005-10:14:41:: i INFO: Processed report.
Report='/Management/Monthly Comparison Report', Stream=''

===============
EXTERNAL INTERNET CONNECTION - Failed
aspnet_wp!library!117c!03/04/2005-10:20:40:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!117c!03/04/2005-10:20:40:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!117c!03/04/2005-10:21:26:: i INFO: Call to
GetPermissions:/Management
aspnet_wp!library!c40!03/04/2005-10:21:26:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1310!03/04/2005-10:21:57:: i INFO: Call to
GetPermissions:/Management/Monthly Comparison Report
aspnet_wp!library!1310!03/04/2005-10:21:57:: i INFO: Call to
GetSystemPermissions

Jeff

[quoted text, click to view]

Jeff Pittenger
3/4/2005 1:40:39 PM
Sean:

We are not alone.
Of course we are in the middle of rolling out reporting services to our
upper mgmt group and there is no going back.
My database admin/report guru is busy designing all the reports thus I have
been asked to solve this problem by next
Friday.
I downloaded this entire group and I see where there have been half-dozen or
so inquiries exactly the same as ours.
No solutions posted though :(

Something wierd that I found was if I go to the URL
http://<servername>/reportserver instead of http://<servername>/reports I
get a generic ftp directory like interface and can browse to my report AND
OPEN IT!
This tells me that it is not a security issue either.
I'm curious as to what gives with the RS Web interface.

Anyone???

Jeff


[quoted text, click to view]

Jeff Pittenger
3/4/2005 3:05:21 PM
Sean:

I just solved the problem here.

In my case, internally I was using http://<servername>/reports and it worked
fine.
From the outside world I had a DNS record for the hostname which was
different from the internal servername http://reports.domain.com/reports.

I went to the SQL server and modified the RSWebApplication.config file.
by default in the c:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report Manager\ directory.

I modified the line beginning with <ReportServerUrl>
originally it was
<ReportServerUrl>http://<servername>/ReportServer</ReportServerUrl>
I modified it to use the complete address in place of <servername>
ie:
<ReportServerUrl>http://reports.domain.com/ReportServer</ReportServerUrl>

Now in order for it to work internally I added a DNS record on my internal
DNS server for the hostname reports.domain.com to point to the internal IP
address of the RS.

That did it for me unfotunately it now asks for authentication even when
acessing from the internal network but I figure most users will check the
remember password box anyway.

Let me know if I can help.

Jeff

[quoted text, click to view]

Imtiaz Ullah
3/4/2005 3:51:41 PM
This is probably a DNS/WINS resolution problem.
Especially if the web address is different to the servername?
Can you ping the server from your PC when out of the network?
Any strange HOSTS entries etc?

Immy
"Jeff Pittenger" <jeff.pittenger@_nospam_kbfundraising_dot_com> wrote in
message news:ukPK2xEIFHA.2744@tk2msftngp13.phx.gbl...
[quoted text, click to view]

Jeff Pittenger
3/4/2005 4:35:32 PM
Adrian:
Thanks for the info that explains it.
My department contacted the installation to a 3rd party to meet tight
deadlines and had no knowledge of the deployment model.
Thank goodness there are experts out there that can help folks like me.

Jeff

[quoted text, click to view]
<ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalUR
L>
[quoted text, click to view]
Adrian M.
3/4/2005 4:59:58 PM
hmm..

See if this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp

Settings in the rswebapplication.config file provide values that are used to
direct requests from Report Manager to a report server. By default, the
configuration file includes ReportServerUrl. Report Manager uses this value
to find the report server that contains server state information and stored
items. In an intranet deployment model, the Report Manager connects to a
report server using a network name (for example,
http://server01/reportserver).

To access a report server on the Internet, you must add a
ReportServerExternalURL configuration setting that specifies the fully
qualified domain name of the report server. The external client uses this
value to access a report server. In this scenario, the browser that is
hosting Report Manager must send a fully qualified domain name when making
requests on behalf of Report Manager to the report server.

The following example illustrates the syntax for ReportServerExternalURL:

<ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>

--
Adrian M.
MCP

"Jeff Pittenger" <jeff.pittenger@_nospam_kbfundraising_dot_com> wrote in
message news:OuHUi3PIFHA.3108@tk2msftngp13.phx.gbl...
[quoted text, click to view]

Jeff Pittenger
3/4/2005 5:25:21 PM
Adrian:

I went back and changed the configuration as recommended in your last post
and unfortunately my problem resurfaced.
I get the page cannot be displayed properly message when accessing any
report.
I was using the internal server name in the <ReportServerURL>parameter and
adding an entry for the <ReportServerServerExternalURL> as recommended.

Modifying the <ReportServerURL> to use FQDN is the only thing that seems to
work.

Jeff

[quoted text, click to view]
<ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalUR
L>
[quoted text, click to view]
Sean Deegan
3/4/2005 7:13:18 PM
Jeff, I'm right there with you...I've got a NATted server as well and am
also using DDNS for name resoultion. Seems to me that if it were a DNS
issue that we would be having trouble getting to the server...but since we
are able to get to the server and have our credentials validated, I think we
can rule that out.

Funny thing though, I think I had this working at one point... but I haven't
been able to put a lot of effort into trying to figure out what the problem
is. Thus the reason I've hit the newsgroups.

Please let me know if you hear anything else about this issue and I'll do
the same as I scour through manuals, blogs and newsgroups.

Sean

"Jeff Pittenger" <jeff.pittenger@_nospam_kbfundraising_dot_com> wrote in
message news:OD1ewkNIFHA.576@TK2MSFTNGP15.phx.gbl...
[quoted text, click to view]

Jeff Pittenger
3/7/2005 11:20:18 AM
Sean:
You are welcome. It's nice to be able to contribue something that helps
another person out.
I wish that the KB article method had worked so that my internal users
arent' prompted for authentication but ...
My guess is that one of the security updates may be one of the culprits.

Jeff

[quoted text, click to view]

Sean Deegan
3/7/2005 2:52:27 PM
Jeff,

Thanks for that info, I too made the changes and it is now working for my
external clients. The changes suggested by the KB article provided by
Adrian also had the same effect on my installation as yours did. So I just
changed the one setting. All seems to be working correctly.

Thanks for working this through with me.

Regards,

Sean
"Jeff Pittenger" <jeff.pittenger@_nospam_kbfundraising_dot_com> wrote in
message news:OuHUi3PIFHA.3108@tk2msftngp13.phx.gbl...
[quoted text, click to view]

Ameet
3/30/2005 6:05:05 AM
Jeff

Your solution saved my hours of research. You the man.

Thanks

Ameet

[quoted text, click to view]
Tom
3/31/2005 4:27:02 PM
My users were also being prompted for credentials when accessing the reports.
I modified the Directory security on the "Report Server" virtual directory
in IIS to anonymous instead of windows integrated and now no prompt.

[quoted text, click to view]
Jeff Pittenger
4/7/2005 1:07:59 PM
I'm not so sure that is a good idea in my case.
Most users are accessing the RS from the Internet.
How would I prevent unauthorized viewers.
Also not all users are allowed to view the same reports.

Jeff

[quoted text, click to view]
AddThis Social Bookmark Button