SSRS Email settings

Ashru 41 Reputation points
2020-08-18T18:02:46.327+00:00

Hi,

SQL Server 2012 Standard

I dont see the column for entering authentication details for smtp server under email settings of SQL Reporting server configuration window. I edited the configuration file and added the userName and Password tags in Rsreportserver.config file but it did not work. As the configuration is not correct, the mail subscription fails with smtp authentication error.

Anyone has an idea on why the all the configuration columns (user name, pwd etc) are not displayed SSRS configuration window? is there any work around to resolve the issue.

Thanks,

Ashru

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.
2,935 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 37,296 Reputation points
    2020-08-19T02:38:42.9+00:00

    Hi,

    Before modify these settings, remember to back up your files.

    By default, SSRS uses anonymous authentication to access the SMTP Server, but most SMTP Servers currently do not support anonymous authentication.

    You need to modify the type of security authentication to access the SMTP Server.

    The configuration file for SSRS is named rsreportserver.config, for SSRS2012 version, the configuration file is stored at

    C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

    In the file, there are 2 important nodes to configure:

    1.Set EnableAuthPersistance to True, comment out RSWindowsNegotiate.

    <Authentication>
    <AuthenticationTypes>
    <!--<RSWindowsNegotiate/>-->
    <RSWindowsNTLM/>
    </AuthenticationTypes>
    <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
    <EnableAuthPersistence>true</EnableAuthPersistence>
    </Authentication>

    2.Configure SMTP Security Authentication

    <SMTPAuthenticate>2</SMTPAuthenticate>

    SMTPAuthenticate specifies how the report server connects to the remote SMTP server. The default value is 0 (or no authentication). In this case, the connection is made through Anonymous access. Depending on your domain configuration, the report server and the SMTP server may need to be members of the same domain.

    To send e-mail to restricted distribution lists (for example, distribution lists that accept incoming messages only from authenticated accounts), set SMTPAuthenticate to 2.

    For reference:

    rsreportserver-config-configuration-file

    IMPORTANT: After you’ve saved the configuration-file, don’t forget to restart the SSRS service on your server.

    Regards,

    Zoe

  2. ZoeHui-MSFT 37,296 Reputation points
    2020-08-20T06:47:21.68+00:00

    Hi Ashru,

    It a pity that my resolution did not work for you.

    I did several research that SSRS2012 did not have the option to enter the user name and password even though we change the config file.

    You may refer this article to set the SMTP server to see if it works or not.
    how-to-configure-ssrs-report-subscriptions-to-use-gmail-for-gp
    configure-email-in-ssrs-2014-on-windows-server-2012

    If this way failed again, I think the easiest way is upgrading SSRS cause SSRS2012 is already out of support in MS side.

    In the newest version of SSRS, it is easy to set up the e-mail settings.

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.