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

sql server reporting services : Some links are being referenced by internal IP address


Calvin.Lai NO[at]SPAM shaw.ca
2/19/2005 12:44:14 PM
ISA Server 2004, ext nic with real internet IP, int nic with IP of
172.17.193.11

IIS 6, SQL 2000 with report services, nic with IP of 172.17.193.8.
Default website with host header value www.domainname.com. Reports
and ReportServer virtual folder located in default website.

To get to reporting services from anywhere on the planet, we do a
www.domainname.com/reports.

User gets a dialog box prompting for domain\username and password
fields.

User gets authenticated, URL becomes
http://www.domainname.com/reports/Pages/Folder.aspx and get the home
page as shown in below screenshot:

http://members.shaw.ca/seks/rptsvc-01.jpg

When user clicks on NEW FOLDER, the URL changes to
http://www.domainname.com/Reports/Pages/FolderProperties.aspx?CreateNew=True&ItemPath=%2fNew+Folder&CancelUrl=http%3a%2f%2f172.17.193.8%2freports%2fPages%2fFolder.aspx,
which is fine.

Click on CONTENTS or PROPERTIES, the URL changes to
http://www.domainname.com/Reports/Pages/......, which is fine.

But when user clicks on UPLOAD FILE, the URL changes to
http://172.17.193.8/Reports/Pages/Import.aspx?ItemPath=%2f&&CancelUrl=http%3a%2f%2f172.17.193.8%2freports%2fPages%2fFolder.aspx
and gets a the server is unreachable error message.

Click on NEW DATA SOURCE, HOME, MY SUBSCRIPTION, SITE SETTINGS, and
HELP, URL also changes to http://172.17.193.8/...............

So why are those links referencing to the int IP address of the web
server? It should be http://www.domainname.com.

Clicking on VIEW | SOURCE in IE:

<td valign="middle"><span id="ui_btnNewFold"><table
id="ui_btnNewFoldTable" width="100%" class="msrs-buttonHeaderButton"
cellpadding="0" cellspacing="0" TITLE="New Folder"
onclick="window.navigate('/Reports/Pages/FolderProperties.aspx?CreateNew=True\u0026ItemPath=%2fNew+Folder\u0026CancelUrl=http%3a%2f%2f172.17.193.8%2freports%2fPages%2fFolder.aspx');"

<td valign="middle"><span id="ui_btnUpload"><table
id="ui_btnUploadTable" width="100%" class="msrs-buttonHeaderButton"
cellpadding="0" cellspacing="0" TITLE="Upload File"
onclick="window.navigate('http://172.17.193.8/Reports/Pages/Import.aspx?ItemPath=%2f\u0026\u0026CancelUrl=http%3a%2f%2f172.17.193.8%2freports%2fPages%2fFolder.aspx');"

As you can see, the NEW FOLDER link is reference by relative path but
the UPLOAD FILE link is reference by full path but by using the
internal ip addrss of the web server which is wrong!

Lukasz Pawlowski [MSFT]
2/21/2005 4:50:46 PM
In your report manager config file (rswebapplication.config). set an
element call <RSEXTERNALURL> to be the host name of the server you need.

Then in the report server config file (rsreportserver.config) set the
<URLROOT> elemetn to specify your host name.

I think that should do it.

Also did you really intend to include your actaul IP address in the post...

-Lukasz


--
This posting is provided "AS IS" with no warranties, and confers no rights.



[quoted text, click to view]

AddThis Social Bookmark Button