Showing posts with label internally. Show all posts
Showing posts with label internally. Show all posts

Sunday, February 26, 2012

Error trying to use host header with SQL Reporting Services

Reporting services was installed to the default web site on server
SQLREPORT. It works fine internally. I have added a host header to the
default web site so that it can be accessed using
http://SQLREPORT.domain.com. I can access the site externally using this
fqdn, and can click on a folder and see reports inside of it. However, when
i choose to run a report, I get
The page cannot be displayed. If I right click in the report area and click
properties,
this is the value that is being shown for Address(URL)
res://C:\WINDOWS\system32\shdoclc.dll/dnserror.htm#http://SQLREPORT/ReportServer?%2fMicrosoft+Operations+Manager+Reporting%2fMicrosoft+Active+Directory%2fADMP+AD+Domain+Controllers&rs:Command=Render&rc:ReplacementRoot=http://SQLREPORT.domain.com/REPORTS/Pages/Report.aspx?ServerUrl=
Is there somewhere in the report or on the server that i need to change
SQLREPORT to SQLREPORT.domain.com? I tried changing it on the server in the
two registry keys for virtual directory, but this did not work either.Found the answer. Requires a change to the registry and to two config files.
Check my blog for more details.
http://www.whitworth.org/blog/PermaLink.aspx?guid=d28de7d8-d036-4d59-b157-5a116c0c5cd9
"Rickey Whitworth" <notprovided@.here> wrote in message
news:eIM5SXpuEHA.3808@.TK2MSFTNGP15.phx.gbl...
> Reporting services was installed to the default web site on server
> SQLREPORT. It works fine internally. I have added a host header to the
> default web site so that it can be accessed using
> http://SQLREPORT.domain.com. I can access the site externally using this
> fqdn, and can click on a folder and see reports inside of it. However,
> when i choose to run a report, I get
> The page cannot be displayed. If I right click in the report area and
> click properties,
> this is the value that is being shown for Address(URL)
> res://C:\WINDOWS\system32\shdoclc.dll/dnserror.htm#http://SQLREPORT/ReportServer?%2fMicrosoft+Operations+Manager+Reporting%2fMicrosoft+Active+Directory%2fADMP+AD+Domain+Controllers&rs:Command=Render&rc:ReplacementRoot=http://SQLREPORT.domain.com/REPORTS/Pages/Report.aspx?ServerUrl=
> Is there somewhere in the report or on the server that i need to change
> SQLREPORT to SQLREPORT.domain.com? I tried changing it on the server in
> the two registry keys for virtual directory, but this did not work either.
>
>