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.
>
>

No comments:

Post a Comment