Friday, May 31, 2013

Setup SSRS email Delivery Option Using Gmail Account

 

In order to use the SSRS email delivery subscription or Data alerts feature, you need to configure the email option. If you don’t have access to the company exchange server, you could configure the system to use a Gmail account instead.  Here are the steps:

Configure a virtual SMTP Server

  • Install SMTP Server window option on the local box or a server.
  • Open IIS 6.0 manager to configure the SMTP option:
    • Click on the Access tab and select Anonymous access option in the Authentication option box

image

    • Click on the Outbound Security option button from the Delivery tab, select the Basic authentication with your Gmail account and enable the TLS Encryption.

image

    • Click on the Outbound connections option button, set the TCP Port number to 587

image

    • Click on the Advance option button, set the Smart Host to use smtp.gmail.com

image

Now you need to configure the SSRS to use the email delivery method. Depend on the SSRS mode, you will do the following:

SSRS Integrated Mode

Open SharePoint 2013 Central Administration and select the Manage Service applications option

image

  • Click on the SQL Server Reporting Services Service to open the configuration page
  • Click on the E-mail Setting link

image 

  • Enable the Use SMTP server option and set the Outbound SMTP server name or IP address; Set the From address to your Gmail address same as you used in the setup IIS step.

image

  • Click on OK button. You are good to go now.

SSRS Native Mode

Open Report Service Configuration manager.

  • Click on the e-mail setting tab
  • Type your Gmail address in the Sender Address on the SMTP Settings window
  • Set the SMTP Server to the server name as previous step

image

  • Click on Apply button. You are good to go now.

Send a SMS text message from email

If you want to send SMS text for the Data Alert. You could type in the 10 digit number with the mobile provider extension as the example below to send the SMNS text.

image

 

Reference

http://www.vsysad.com/2012/04/setup-and-configure-smtp-server-on-windows-server-2008-r2/

http://www.nytimes.com/2011/11/03/technology/personaltech/how-to-send-text-messages-by-e-mail.html?_r=0

3 comments:

  1. Hi,Before we can put our existing businesses on the web we will have to plan because there are a lot of issues related with Incorporation in Qatar with having an online presence.thanks.....

    ReplyDelete
  2. The experts are always trying their best to provide you with services that are perfect and ideal and hence you can be sure that all the help and solution they would be providing you with would ensure that your account is functioning perfectly well and does not lag in any sense.http://lockerdome.com/8906028448404545/8906030126118930

    ReplyDelete
  3. There is port setting in rsreportserver.config file. default is . I put 587 port: 587. SSRS should be restarted. After that SSRS sends e-mail directly onto GMAIL.com.
    Other settings are: smtp server=smtp.gmail.com; user= just_user_name; password=...; secure connection = YES.

    ReplyDelete