Wednesday, March 7, 2012

Problem when accessing RS using fully qualified name or IP.

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 PlatformHelloooo 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
"Nayan" wrote:
> 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
>

No comments:

Post a Comment