How to configure the mail relay for Report Manager

Last Modified

Thu Sep 06 15:13 GMT 2018

Description

  • Scheduled Report not sent by email.
  • The mail relay for Report Manager is set directly on the Report Manager server, rather than in N-able N-central . These steps will help with initial configuration as well as modification of this setting.


Example Error:

library!WindowsService_34!6a4!05/01/2018-10:43:07:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.notification!WindowsService_34!6a4!05/01/2018-10:43:07:: i INFO: Handling subscription 3c3c7636-6a5c-491c-a7fb-3a04c9b1883d to report Hardware Inventory Report, owner: EXAMPLEDOMAIN\reportmanager, delivery extension: Report Server Email.library!WindowsService_34!6a4!05/01/2018-10:43:07:: i INFO: RenderForNewSession('/Reports/Hardware Inventory Report')library!WindowsService_34!6a4!05/01/2018-10:43:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;library!WindowsService_34!6a4!05/01/2018-10:43:07:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.emailextension!WindowsService_34!6a4!05/01/2018-10:43:07:: e ERROR: Error sending email. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error.  ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. notification!WindowsService_34!6a4!05/01/2018-10:43:07:: i INFO: Notification a1b137c3-7d02-4ecc-92a6-b786d8369b61 completed.  Success: True, Status: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent., DeliveryExtension: Report Server Email, Report: Hardware Inventory Report, Attempt 0library!WindowsService_34!db0!05/01/2018-10:49:30:: i INFO: Call to CleanBatch()

Environment

  • Report Manager All Supported Versions

Solution

Report Manager reports are sent via the SQL server's mail relay settings.
  1. Open SQL Server Reporting Services Configuration Manager from the Report Manager server's Start Menu
  2. Connect to the appropriate instance of SQL - for Report Manager, this should be the default MSSQLSERVER
  3. On the Email Settings page, enter the appropriate SMTP relay information.
  4. In Sender Address, enter an email address that can relay email through your mail relay server
  5. Click Apply
Note: If your mail relay server requires authentication, SQL Server 2016 has a setting for this in SQL Server Reporting Services. For earlier versions of SQL, you may need to edit certain configuration files, which are not part of Report Manager and not supported by N-able. You can refer to this Microsoft Documentation for more information: https://msdn.microsoft.com/en-us/library/ms159155(v=sql.120).aspx