Report Server E-Mail Configuration - Permitted Hosts

Hi all,

I would like to configure the permitted hosts setting for the Report Server. According to MSDN, the Syntax is:

 <PermittedHosts>
          <HostName>Adventure-Works.com</HostName>
          <HostName>hotmail.com</HostName>
     </PermittedHosts>

In case of having only one host, is the <HostName> tag mandatory? I was not able to find more information regarding the xsd on which the configuration file is based. To be more specific, is it possible to define the PermittedHost like this or will this result in an error?

 <PermittedHosts>Adventure-Works.com</PermittedHosts>

Thank you for your answer,

Patrick

August 25th, 2015 1:45am

Hi Aquantos,

Based on the current information, the settings in the RSreportserver.config file might not be set automatically after you applied the settings from the Reporting Services Configuration Manager. Here, I suggest that you refer to the following steps:

  1. Navigate to <Drive>:\Program Files\Microsoft SQL Server\MSRS10.<Instance Name>\Reporting Services\ReportServer folder, and make a copy of the RSReportServer.config file.
  2. Open the RSReportServer.config file in a text editor.
  3. Verify that <UrlRoot> is set to the report server URL address. This value is set when you configure the report server and it should be filled in already. If it is not set, type the report server URL address.
  4. In the Delivery section, find <ReportServerEmail>.
  5. In <SMTPServer>, type the name of the SMTP server. This value can be an IP address, a UNC name of a computer on your corporate intranet, or a fully qualified domain name.
  6. Verify that <SendUsing> is set to 2. If it is set another value, the report server is not configured to use a remote SMTP service.
  7. In <From>, type the name an account that has permission to send e-mail from the SMTP server.
  8. Save the file.

The report server will use the new settings automatically; you do not need to restart the service.

The RSEmailDPConfiguration part of the RSreportserver.config is as follows:

<RSEmailDPConfiguration>
     <SMTPServer>mySMTPServer.Adventure-Works.com</SMTPServer>
     <SMTPServerPort></SMTPServerPort>
     <SMTPAccountName></SMTPAccountName>
     <SMTPConnectionTimeout></SMTPConnectionTimeout>
     <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
     <SMTPUseSSL></SMTPUseSSL>
     <SendUsing>2</SendUsing>
     <SMTPAuthenticate></SMTPAuthenticate>
     <From>my-rs-email-account@Adventure-Works.com</From>
     <EmbeddedRenderFormats>
          <RenderingExtension>MHTML</RenderingExtension>
     </EmbeddedRenderFormats>
     <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
     <ExcludedRenderFormats>
          <RenderingExtension>HTMLOWC</RenderingExtension>
          <RenderingExtension>NULL</RenderingExtension>
     </ExcludedRenderFormats>
     <SendEmailToUserAlias>True</SendEmailToUserAlias>
     <DefaultHostName></DefaultHostName>
     <PermittedHosts>
          <HostName>Adventure-Works.com</HostName>
          <HostName>hotmail.com</HostName>
     </PermittedHosts>
</RSEmailDPConfiguration>

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 2:08am

Hi Milan, thank you for your quick response. However, this is not really an answer to my specific question. Or I do not understand your answer fully, sorry :-) My question was whether the <HostName>-Tag could be omitted from the <PermittedHosts> setting. Specifically, is the following entry a valid entry for the PermittedHosts section of the RSEmailDPCOnfiguration part of the RSreportserver.config?

<PermittedHosts>Adventure-Works.com</PermittedHosts>

Or is it mandatory to declare the Host in the following manner?

<PermittedHosts><HostName>Adventure-Works.com</HostName></PermittedHosts>

Thank you, Patrick

August 25th, 2015 2:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics