How to use gmail account for ssrs email subscription

Question

I have a report using SSRS 2008 R2, I want to subscribe to this report using the "email" option. I have configured the settings in the reporting services manager to use server as "smtp.gmail.com" and sender address as my gmail ID.

I also tried using the SMTP virtual server and relay it using smart host as "smtp.gmail.com". But I get the following error while sending email :

Failure sending mail: The transport failed to connect to the server.

I am using IIS 7 and Windows Server 2008. Following is the snippet of my rsreportserver.config file:

<SMTPServer>smtp.gmail.com</SMTPServer>
<SMTPServerPort>587
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
</SMTPServerPickupDirectory>
<SMTPUseSSL>True
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>[email protected]</From>

Any help will be highly appreciated. Thanks

Answer 1

I was having a problems getting SSRS 2017 to connect. I tried a dozen different suggestions and ended up with the following. I didn't need to setup the SMTP relay or SMTP service on the windows server.

Open Reporting Services Configuration Manager. Go to E-mail Settings >>>

• Sender Address: [user]@gmail.com (or your G-Suite domain)
• Current Delivery Method: Use SMTP server
• SMTP Server: smtp.gmail.com
• Authentication= "Username and password (basic)"
• Username: [user]@gmail.com (or your G-Suite domain)
• Password
• Confirm Password
• Use Secure Connection: Checked

Now go to the rsreportserver.config file. Mine was located at C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\rsreportserver.config

Find the <SMTPServerPort> and set to 587

Save rsreportserver.config