Broken link in e-mail subscription

I have scheduled the first report at this customers site to send out e-mails
of reports. It is sending out the report just fine and including the PDF
file that I requested however I also checked the Include Link box in the
schedule because of the requirements of the users wanting to hide details in
the e-mailed report and wanting to link to the report and then drill down to
see the details only when necessary.
When the e-mail is sent it doesn't formulate the URL correctly and says the
following:
The report is accessible at the following address:
http://localhost/reports?%2fAccounting%.........
The closest thing I've found online to resolve this was this link:
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm
-- See "Incomplete Report Server Configuration on an SSL-Protected Server
Causes Broken Report Links in Report Server E-Mail Notifications" section.
Unfortunately, an examination of the suggestion revealed that we are not
using SSL and when I checked the <UrlRoot> in the RSReportServer.config file
it was set correctly to the server name that I'd want used in replacing
localhost in the URL.
Does anyone know how to fix this?You'll actually need to modify the rswebapplication.config file for that
setting.
The section should look like the following to get your issue resolved:
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> I have scheduled the first report at this customers site to send out
e-mails
> of reports. It is sending out the report just fine and including the PDF
> file that I requested however I also checked the Include Link box in the
> schedule because of the requirements of the users wanting to hide details
in
> the e-mailed report and wanting to link to the report and then drill down
to
> see the details only when necessary.
> When the e-mail is sent it doesn't formulate the URL correctly and says
the
> following:
> The report is accessible at the following address:
> http://localhost/reports?%2fAccounting%.........
> The closest thing I've found online to resolve this was this link:
>
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
25641/ReadmeSQL2005.htm
> -- See "Incomplete Report Server Configuration on an SSL-Protected
Server
> Causes Broken Report Links in Report Server E-Mail Notifications" section.
> Unfortunately, an examination of the suggestion revealed that we are not
> using SSL and when I checked the <UrlRoot> in the RSReportServer.config
file
> it was set correctly to the server name that I'd want used in replacing
> localhost in the URL.
> Does anyone know how to fix this?
>|||Thanks for the quick reply!
That didn't work; the e-mailed report still says localhost. Does it require
a reboot of the server or the service?
I changed two files named rswebapplication.config located here on the server:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
and
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
Any ideas?
Thanks,
Keith
"Chris Alton [MSFT]" wrote:
> You'll actually need to modify the rswebapplication.config file for that
> setting.
> The section should look like the following to get your issue resolved:
> <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> >
> > I have scheduled the first report at this customers site to send out
> e-mails
> > of reports. It is sending out the report just fine and including the PDF
> > file that I requested however I also checked the Include Link box in the
> > schedule because of the requirements of the users wanting to hide details
> in
> > the e-mailed report and wanting to link to the report and then drill down
> to
> > see the details only when necessary.
> >
> > When the e-mail is sent it doesn't formulate the URL correctly and says
> the
> > following:
> >
> > The report is accessible at the following address:
> > http://localhost/reports?%2fAccounting%.........
> >
> > The closest thing I've found online to resolve this was this link:
> >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> 25641/ReadmeSQL2005.htm
> > -- See "Incomplete Report Server Configuration on an SSL-Protected
> Server
> > Causes Broken Report Links in Report Server E-Mail Notifications" section.
> >
> > Unfortunately, an examination of the suggestion revealed that we are not
> > using SSL and when I checked the <UrlRoot> in the RSReportServer.config
> file
> > it was set correctly to the server name that I'd want used in replacing
> > localhost in the URL.
> >
> > Does anyone know how to fix this?
> >
> >
>|||If you have two instances of Reporting Services installed then you need to
figure out which instance you are connecting to and modify the correct
configuration files. Also, if you modified the rsreportserver.config file
for the wrong instance then that could have caused it as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> X-WBNR-Posting-Host: 64.4.185.178
> From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
<8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Broken link in e-mail subscription
> Thanks for the quick reply!
> That didn't work; the e-mailed report still says localhost. Does it
require
> a reboot of the server or the service?
> I changed two files named rswebapplication.config located here on the
server:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager
> and
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager
> Any ideas?
> Thanks,
> Keith
>
> "Chris Alton [MSFT]" wrote:
> > You'll actually need to modify the rswebapplication.config file for
that
> > setting.
> >
> > The section should look like the following to get your issue resolved:
> > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > >
> > > I have scheduled the first report at this customers site to send out
> > e-mails
> > > of reports. It is sending out the report just fine and including the
PDF
> > > file that I requested however I also checked the Include Link box in
the
> > > schedule because of the requirements of the users wanting to hide
details
> > in
> > > the e-mailed report and wanting to link to the report and then drill
down
> > to
> > > see the details only when necessary.
> > >
> > > When the e-mail is sent it doesn't formulate the URL correctly and
says
> > the
> > > following:
> > >
> > > The report is accessible at the following address:
> > > http://localhost/reports?%2fAccounting%.........
> > >
> > > The closest thing I've found online to resolve this was this link:
> > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > 25641/ReadmeSQL2005.htm
> > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > Server
> > > Causes Broken Report Links in Report Server E-Mail Notifications"
section.
> > >
> > > Unfortunately, an examination of the suggestion revealed that we are
not
> > > using SSL and when I checked the <UrlRoot> in the
RSReportServer.config
> > file
> > > it was set correctly to the server name that I'd want used in
replacing
> > > localhost in the URL.
> > >
> > > Does anyone know how to fix this?
> > >
> > >
> >
> >
>|||Welp, I didn't know I had a second instance, but you were right! I have it
fixed.
One thing though, I couldn't google a fix to this problem. Perhaps there is
something that could be added to BOL? Or did I miss it?
"Chris Alton [MSFT]" wrote:
> If you have two instances of Reporting Services installed then you need to
> figure out which instance you are connecting to and modify the correct
> configuration files. Also, if you modified the rsreportserver.config file
> for the wrong instance then that could have caused it as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > X-WBNR-Posting-Host: 64.4.185.178
> > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Broken link in e-mail subscription
> >
> > Thanks for the quick reply!
> >
> > That didn't work; the e-mailed report still says localhost. Does it
> require
> > a reboot of the server or the service?
> >
> > I changed two files named rswebapplication.config located here on the
> server:
> > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager
> > and
> > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager
> >
> > Any ideas?
> >
> > Thanks,
> > Keith
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You'll actually need to modify the rswebapplication.config file for
> that
> > > setting.
> > >
> > > The section should look like the following to get your issue resolved:
> > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Broken link in e-mail subscription
> > > >
> > > > I have scheduled the first report at this customers site to send out
> > > e-mails
> > > > of reports. It is sending out the report just fine and including the
> PDF
> > > > file that I requested however I also checked the Include Link box in
> the
> > > > schedule because of the requirements of the users wanting to hide
> details
> > > in
> > > > the e-mailed report and wanting to link to the report and then drill
> down
> > > to
> > > > see the details only when necessary.
> > > >
> > > > When the e-mail is sent it doesn't formulate the URL correctly and
> says
> > > the
> > > > following:
> > > >
> > > > The report is accessible at the following address:
> > > > http://localhost/reports?%2fAccounting%.........
> > > >
> > > > The closest thing I've found online to resolve this was this link:
> > > >
> > >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > 25641/ReadmeSQL2005.htm
> > > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > > Server
> > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> section.
> > > >
> > > > Unfortunately, an examination of the suggestion revealed that we are
> not
> > > > using SSL and when I checked the <UrlRoot> in the
> RSReportServer.config
> > > file
> > > > it was set correctly to the server name that I'd want used in
> replacing
> > > > localhost in the URL.
> > > >
> > > > Does anyone know how to fix this?
> > > >
> > > >
> > >
> > >
> >
>|||I'm sure its in Books Online somewhere. It has to get the link for the
report from somewhere and if it is configured as localhost in all the
configuration files then its going to use localhost.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> Welp, I didn't know I had a second instance, but you were right! I have
it
> fixed.
> One thing though, I couldn't google a fix to this problem. Perhaps there
is
> something that could be added to BOL? Or did I miss it?
> "Chris Alton [MSFT]" wrote:
> > If you have two instances of Reporting Services installed then you need
to
> > figure out which instance you are connecting to and modify the correct
> > configuration files. Also, if you modified the rsreportserver.config
file
> > for the wrong instance then that could have caused it as well.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > > X-WBNR-Posting-Host: 64.4.185.178
> > > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?=<greenmtnsun@.discussions.microsoft.com>
> > > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> > <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: Broken link in e-mail subscription
> > >
> > > Thanks for the quick reply!
> > >
> > > That didn't work; the e-mailed report still says localhost. Does it
> > require
> > > a reboot of the server or the service?
> > >
> > > I changed two files named rswebapplication.config located here on the
> > server:
> > > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> > Services\ReportManager
> > > and
> > > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportManager
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You'll actually need to modify the rswebapplication.config file for
> > that
> > > > setting.
> > > >
> > > > The section should look like the following to get your issue
resolved:
> > > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: Broken link in e-mail subscription
> > > > >
> > > > > I have scheduled the first report at this customers site to send
out
> > > > e-mails
> > > > > of reports. It is sending out the report just fine and including
the
> > PDF
> > > > > file that I requested however I also checked the Include Link box
in
> > the
> > > > > schedule because of the requirements of the users wanting to hide
> > details
> > > > in
> > > > > the e-mailed report and wanting to link to the report and then
drill
> > down
> > > > to
> > > > > see the details only when necessary.
> > > > >
> > > > > When the e-mail is sent it doesn't formulate the URL correctly
and
> > says
> > > > the
> > > > > following:
> > > > >
> > > > > The report is accessible at the following address:
> > > > > http://localhost/reports?%2fAccounting%.........
> > > > >
> > > > > The closest thing I've found online to resolve this was this link:
> > > > >
> > > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > > 25641/ReadmeSQL2005.htm
> > > > > -- See "Incomplete Report Server Configuration on an
SSL-Protected
> > > > Server
> > > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> > section.
> > > > >
> > > > > Unfortunately, an examination of the suggestion revealed that we
are
> > not
> > > > > using SSL and when I checked the <UrlRoot> in the
> > RSReportServer.config
> > > > file
> > > > > it was set correctly to the server name that I'd want used in
> > replacing
> > > > > localhost in the URL.
> > > > >
> > > > > Does anyone know how to fix this?
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>