Email Subsciption not available in SSRS

Nikko Zurawski 21 Reputation points
2021-01-14T19:13:15.507+00:00

I have created and configured a Report Server and the Report Builder and setup email on it. When I click apply for email settings under the SSRS config manager, it said the setting were saved successfully. Still, when I got to manage a report and choose subscriptions, the email type is not available, only file share. Is there a step I'm missing?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,065 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,636 Reputation points
    2021-01-15T02:02:27.793+00:00

    Hi @Nikko Zurawski
    First of all, make sure that you have completed configuring the mail setting options in the report manager, as shown below:

    56943-01.jpg

    Be sure to restart the server when the settings are complete:

    56854-02.jpg

    Based on the current information, it seems that the E-mail Delivery extension is disabled in the RSreportserver.config file. To avoid the issue, please refer to the following steps:

    1.Navigate to <Drive>:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer folder, open the RSReportserver.config file.
    2.Check whether the following <Extension> element is in the <DeliveryUI> configuration in the RSreportserver.config file:

    </Extension>  
     <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">  
     <MaxRetries>3</MaxRetries>  
     <SecondsBeforeRetry>900</SecondsBeforeRetry>  
     <Configuration>  
     <RSEmailDPConfiguration>  
     <SMTPServer></SMTPServer>  
     <SMTPServerPort>  
     </SMTPServerPort>  
     <SMTPAccountName>  
     </SMTPAccountName>  
     <SMTPConnectionTimeout>  
     </SMTPConnectionTimeout>  
     <SMTPServerPickupDirectory>  
     </SMTPServerPickupDirectory>  
     <SMTPUseSSL>False</SMTPUseSSL>  
     <SendUsing>2</SendUsing>  
     <SMTPAuthenticate>0</SMTPAuthenticate>  
     <SendUserName></SendUserName>  
     <SendPassword></SendPassword>  
     <From></From>  
     <EmbeddedRenderFormats>  
     <RenderingExtension>MHTML</RenderingExtension>  
     </EmbeddedRenderFormats>  
     <PrivilegedUserRenderFormats>  
     </PrivilegedUserRenderFormats>  
     <ExcludedRenderFormats>  
     <RenderingExtension>HTMLOWC</RenderingExtension>  
     <RenderingExtension>NULL</RenderingExtension>  
     <RenderingExtension>RGDI</RenderingExtension>  
     </ExcludedRenderFormats>  
     <SendEmailToUserAlias>True</SendEmailToUserAlias>  
     <DefaultHostName>  
     </DefaultHostName>  
     <PermittedHosts>  
     </PermittedHosts>  
     </RSEmailDPConfiguration>  
     </Configuration>  
     </Extension>  
    

    3.If not, please make a copy of the RSreportserver.config file, and then add the above element between the two <DeliveryUI> attributes.
    4.Save the file.

    For more information, please refer to : RsReportServer.config Configuration File

    Here is a very detailed tutorial to help you understand: Configure email notifications for Configuration Manager reports.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Nikko Zurawski 21 Reputation points
    2021-01-15T19:28:09.71+00:00

    Thank you for the reply. I'm afraid I have some egg on my face as the answer was as simple as just restarting SSRS after I configured the email settings.

    Very sorry to have wasted your time.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.