How to configure SSRS Report Subscriptions to use Gmail for GP
February 23 |
By Ryan McBee
1. You need to install the SMTP feature on your Windows Server instance. In Server Manager go to the features section and click on Add Features.
2. Create and setup a Gmail account at http://www.gmail.com
3. Enable the Gmail account for POP3 in Gmail, you can follow the instructions on how to do this here: http://mail.google.com/support/bin/answer.py?answer=13273&cbid=wl8yzeug2lob&src=cb&lev=topic
We will now configure the IIS Server to forward messages using the Gmail account.
Open IIS Manager
Right Click “IIS SMTP Virtual server”
Select the “Access” Tab
Make sure “All except the list below” is selected
You can add servers to this list that you want to block from sending mail to this server if you press “Add”
Select the “Delivery” Tab
Click “Outbound Security”
Select “Basic Authentication”
Enter your Gmail account (i.e. email@example.com)
Enter your Gmail password
Select “TLS encryption”
Click “Outbound connections” and set TCP port to “587″
Click “Advanced” and enter the Full-qualified domain name – this should be what you want this SMTP server to be called. If your server name is “SMTP” and your domain is “YOURDOMAIN.COM” then the entry should be “smtp.yourdomain.com”
Enter “smtp.gmail.com” as the “Smart host”
Now configure the outbound email server in your application to use “gmail.yourdomain.com” and it should relay the email through Gmail.
Click on “OK” twice to complete the setup of the SMTP server.
The last thing that remains to be done is to configure Reporting Services to use our virtual SMTP server. You can do that by running the Reporting Services Configuration Manager utility.
Type in the email address that will be shown as the sender when SSRS sends emails. (This may be over written by the remote SMTP server so check to see if this is the case. In this example the Google SMTP server will replace any address that you enter here with the email address of the account used to authenticate to it and send emails with.). In the “SMTP Server” textbox type the IP address that you selected for the virtual SMTP server.
Click on “Apply” and then “Exit” after the settings have been applied successfully. Reporting Services is now configured to send emails via the local virtual SMTP server which will relay the emails using the Remote SMTP server using basic authentication.