SSRS Email settings

Question

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

Answer 1

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

Answer 2

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.