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

sql server reporting services : Problem when accessing RS using fully qualified name or IP.


Nayan
11/24/2005 2:57:01 PM
Hi,

I am using Reporting Services 2000 running on Win2k3. I have admin rights
for this machine.

Everything works just great if I am accessing Reporting services in our
intranet using http://server1/reports or http://server1/reportserver

But, When I view reports using fully qualified name e.g.
http://server1.mydomain.com/reports after entering username/password it shows
first page and when I click on any report item I get "The page cannot be
displayed" in the bottom frame.

Weird thing is if I access reports using
http://server1.mydomain.com/reportserver (simple file browse view) instead
of http://server1.mydomain.com/reports everything works fine.

Here is what I have tried after reading several posts.

I edited RSWebApplication.config located at
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\

Old setting:
<ReportServerUrl>http://server1/ReportServer</ReportServerUrl>

New Setting:
<ReportServerUrl>http://server1.mydomain.com/ReportServer</ReportServerUrl>

When I apply the above setting I get the following error on the very first
page.

"The request failed with HTTP status 401: Unauthorized. "

I also edited RSReportServer.config located under \ReportServer folder but
still same error.

"The request failed with HTTP status 401: Unauthorized. "

Any help will be greatly appreciated.

Thx!

--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform
Nayan
11/24/2005 6:08:02 PM
Helloooo guys, I found the solution.

After reading MSDN I found that <ReportServerExternalUrl> tag must be added
to use FQDN so you can access RS over internet. Report manager will use this
URL to redirect to the report server.

Modify the RSWebApplication.Config file located under \ReportManager folder
as below

e.g.
<UI>
<ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
<ReportServerExternalUrl>http://server1.mydomain.com/ReportServer</ReportServerExternalUrl>
</UI>

Correction to MSDN statement.
====================
MSDN has half way correct information. MSDN states <ReportServerURL> must be
added but it has to be <ReportServerUrl> instead <ReportServerURL> (Note:
XML is case sensitive).

If you enter <ReportServerURL> instead <ReportServerUrl> you will get the
following error.

"The configuration file contains an element that is not valid. The
ReportServerExternalURL element is not a configuration file element."


--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform




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