none
SSRS E-Mail Settings and Office 365 E-Mail Account

    Question

  • Hi,

    I would like to configure my Reporting Services so that a group of end-users can subscribe to a series of reports, but my email account resides on O365 and I don't know what values to use for the email settings.

    Any suggestions would be greatly appreciated.

    Saeed Fattahi


    Saeed Fattahi .NET Specialist


    Wednesday, June 19, 2013 1:07 PM

Answers

All replies

  • Hi Saeed,

    you can follow this msdn.microsoft.com/.../ms159155.aspx

    the settings you must set is SMTPAuthenticate with the user account from Office 365 (ie the account must have an Exchange mailbox on Office 365)


    Live life with joy and happiness! Avanish

    Wednesday, June 19, 2013 4:27 PM
  • Configure below setting for sending email through SSRS

    In SQL server configuration manger>E Mail Setting>

    Sender address - group@domain.com or user@domain.com

    Current SMTP Delivery method - USE SMTP Server

    SMTP Server - 10.10.10.10 put here smtp server name or ip address of the same.

    now go to report on http://servername/reports/xxxx

    and go to option subscribe click on that a new page will open on where every this self explanatory.

    Hope this will help you....

    Wednesday, June 19, 2013 4:55 PM
  • Thanks Avanish, but my question is what should use as my SMTP server, since the mailbox is on O365:)

    I can't use mail.mydomain.com anymore! True?

     

    Saeed Fattahi .NET Specialist

    Wednesday, June 19, 2013 11:43 PM
  • Hello,

    Windows Server supports an SMTP relay for Office 365.Please refer to the following article about set up a Simple Mail Transfer Protocol (SMTP) relay in Microsoft Office 365.
    Reference:  http://support.microsoft.com/kb/2600912
                     http://www.configureoffice365.com/configure-office-365-smtp-applications-and-devices/

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Friday, June 21, 2013 7:47 AM
  • Thank you Fanny:)

    I configured SMTP Relay n my server and it is working like a charm.


    Saeed Fattahi .NET Specialist

    Tuesday, June 25, 2013 9:31 AM
  • Hi Fanny:(

    My SMTP Relay worked fine for 2 days, and then emails started piling up in my "mailroot\badmail" directory:(

    I'm not sure I'm missing anything in my SSRS Config File! Please take a peak at my config to see I'm missing anything:

                <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
                    <MaxRetries>3</MaxRetries>
                    <SecondsBeforeRetry>900</SecondsBeforeRetry>
                    <Configuration>
                        <RSEmailDPConfiguration>
                            <SMTPServer>MY.IP.ADD.RES</SMTPServer>
                            <SMTPServerPort>
                            </SMTPServerPort>
                            <SMTPAccountName>
                            </SMTPAccountName>
                            <SMTPConnectionTimeout>
                            </SMTPConnectionTimeout>
                            <SMTPServerPickupDirectory>
                            </SMTPServerPickupDirectory>
                            <SMTPUseSSL>
                            </SMTPUseSSL>
                            <SendUsing>2</SendUsing>
                            <SMTPAuthenticate>
                            </SMTPAuthenticate>
                            <From>MyMail@MySite.com</From>
                            <EmbeddedRenderFormats>
                                <RenderingExtension>MHTML</RenderingExtension>
                            </EmbeddedRenderFormats>
                            <PrivilegedUserRenderFormats>
                            </PrivilegedUserRenderFormats>
                            <ExcludedRenderFormats>
                                <RenderingExtension>HTMLOWC</RenderingExtension>
                                <RenderingExtension>NULL</RenderingExtension>
                                <RenderingExtension>RGDI</RenderingExtension>
                            </ExcludedRenderFormats>
                            <SendEmailToUserAlias>True</SendEmailToUserAlias>
                            <DefaultHostName>
                            </DefaultHostName>
                            <PermittedHosts>
                            </PermittedHosts>
                        </RSEmailDPConfiguration>
                    </Configuration>
                </Extension>

    Thanks in advance;

    Saeed


    Saeed Fattahi .NET Specialist


    Monday, July 01, 2013 11:13 PM