Wednesday, June 9, 2010

Email Configuration for SSRS:

Below is the procedure to configure an email account for SSRS.

1. Open reporting service configuration manager and connect to the report server.
2. In the Email setting tab, provide SMTP Server name and an email account that can send emails from the provided SMTP server.


Report Server subscriptions might fail to send an email if the remote SMTP server is used with the below error message:

The Error message: Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.1 Client was not authenticated) (PFA – SMTP configuration & Error message)

This is because, if the SMTP server provided in report server configuration is other than local, there is small configuration change that needs to be updated in “RSreportserver.config” file which is located at “C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer”.

1. Open RSreportserver.config file and look for “SendUsing”. This value must set to 2 if we use remote SMTP server.
2. Look for SMTPAuthenticate and set its value to 2. This is to send emails to restricted distribution list that accept mails only through authenticated accounts.
3. After all it should be something like below .

"SMTPServer"smtp.adminworks.com"/SMTPServer"
"SMTPServerPort"25 "/SMTPServerPort"
"SMTPAccountName" "/SMTPAccountName"
"SMTPConnectionTimeout" "/SMTPConnectionTimeout"
"SMTPServerPickupDirectory" "/SMTPServerPickupDirectory"
"SMTPUseSSL" "/SMTPUseSSL"
"SendUsing"2"/SendUsing"
"SMTPAuthenticate"2"/SMTPAuthenticate"
"From"admin@local.com "/From"

No comments:

Post a Comment

Post a Comment