none
Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first for gmail in SQL server reporting services

    Question

  • Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first 

    Excuse me how can fix or solve this problem immediately plz 

    for gmail and any smtp 

    and this is the configuration in Rsreportserver.config

    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
    <MaxRetries>3</MaxRetries>
    <SecondsBeforeRetry>900</SecondsBeforeRetry>
    <Configuration>
    <RSEmailDPConfiguration>
    <SMTPServer>smtp.gmail.com</SMTPServer>
    <SMTPServerPort>
    </SMTPServerPort>
    <SMTPAccountName>
    </SMTPAccountName>
    <SMTPConnectionTimeout>
    </SMTPConnectionTimeout>
    <SMTPServerPickupDirectory>
    </SMTPServerPickupDirectory>
    <SMTPUseSSL>
    </SMTPUseSSL>
    <SendUsing>2</SendUsing>
    <SMTPAuthenticate>
    </SMTPAuthenticate>
    <From>ingfernandoc@gmail.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>

    how can solve this problem??? 

    best regards

    Friday, February 22, 2013 7:44 PM

All replies

  • Per this post here:

    The built-in SMTP delivery channel doesn't support authentication or TLS. To send email you'll either need to find another server through which to send your notifications, or implement a custom delivery channel.

    You can relay through the STMP server built into Windows Server per this blog post:

    How to configure SSRS Report Subscriptions to use Gmail for GP

    • Proposed as answer by Jordan At Kawa Friday, February 22, 2013 8:27 PM
    Friday, February 22, 2013 8:26 PM
  • and for hotmail smpt and yahoo smtp????????????

    and how install  the SMTP feature on your Windows Server instance.  In Server Manager go to the features section and click on Add Features.

    im using windows 7

    how can i do????

    Monday, February 25, 2013 1:18 PM
  • re: Hotmail and yahoo smtp

    The required settings "TSL/SSL", ports, etc are specific to each provider. You would need to check their documentation.

    For example:

    A quick search found the following:
    http://help.yahoo.com/l/us/yahoo/smallbusiness/bizmail/pop/pop-33.html
    http://windows.microsoft.com/en-US/hotmail/send-receive-email-from-mail-client

    Each company will provide the specific smpt/pop info for their service and you will need to adjust your settings accordingly.  If you're not sure what these settings mean I suggest that you take a step back and learn a little about how IP Addresses, ports, TLS and SMTP gateways work. (I know this isn't the best answer, but sometimes it helps to understand the underlying components.)

    The long and short:
    TLS and SSL are encryption tunnels between 2 points (ex: your computer and one of Google's servers).  How they shake hands and implement that tunnel are what differentiate TLS, SSL (and the various versions of each).

    http://en.wikipedia.org/wiki/Secure_Sockets_Layer

    re: Running an SMTP gateway in Windows 7

    I have not tried this before, but the SMTP gateway is actually built into IIS (as apposed to it being its own role) and is apparently available on Windows 7.

    You will need to make sure that IIS 7 is already configured on your system:
    http://technet.microsoft.com/en-us/library/cc725762.aspx

    And then this article should discuss utilizing the feature.

    http://technet.microsoft.com/en-us/library/cc772058%28v=WS.10%29.aspx

    Sorry if I'm being a little vague but I don't have direct experience configuring this on Win 7.

    Tuesday, February 26, 2013 12:19 AM
  • re: Hotmail and yahoo smtp

    The required settings "TSL/SSL", ports, etc are specific to each provider. You would need to check their documentation.

    For example:

    A quick search found the following:
    http://help.yahoo.com/l/us/yahoo/smallbusiness/bizmail/pop/pop-33.html
    http://windows.microsoft.com/en-US/hotmail/send-receive-email-from-mail-client

    Each company will provide the specific smpt/pop info for their service and you will need to adjust your settings accordingly.  If you're not sure what these settings mean I suggest that you take a step back and learn a little about how IP Addresses, ports, TLS and SMTP gateways work. (I know this isn't the best answer, but sometimes it helps to understand the underlying components.)

    The long and short:
    TLS and SSL are encryption tunnels between 2 points (ex: your computer and one of Google's servers).  How they shake hands and implement that tunnel are what differentiate TLS, SSL (and the various versions of each).

    http://en.wikipedia.org/wiki/Secure_Sockets_Layer

    re: Running an SMTP gateway in Windows 7

    I have not tried this before, but the SMTP gateway is actually built into IIS (as apposed to it being its own role) and is apparently available on Windows 7.

    You will need to make sure that IIS 7 is already configured on your system:
    http://technet.microsoft.com/en-us/library/cc725762.aspx

    And then this article should discuss utilizing the feature.

    http://technet.microsoft.com/en-us/library/cc772058%28v=WS.10%29.aspx

    Sorry if I'm being a little vague but I don't have direct experience configuring this on Win 7.

    ok

    I´m trying to say with out smtp(simple mail transport protocol) email configuration

    i want the email subscription on ssrs(SQL server reporting services) without smtp(simple mail transport protocol) email  Configuration from iis

    pd:the sql server database works with sending email and work with c# code

    thanks

    regards


    Wednesday, February 27, 2013 2:38 PM
  • Unfortunately SSRS appears to be using an old email library.  TLS is newer then SSL and for whatever reason MS did not update their email library in SSRS to support it (or at the very least expose the TLS setting).

    As a result we're forced to use these hacks/work arounds to get SSRS to connect to services that use TLS.

    Your email provider (Google, Hotmail, Exchange, etc) can configure their smtp server security in any number of ways.  Because Google (in this case) chose to go with the newer (and more secure) TLS, we (the programmer or client application) are on the hook for supporting it.  There is no way to connect by any other means/protocol, and again MS has yet to update their code to add support. 

    Is it possible for MS to add TLS support to SSRS? Absolutely!  I've written my own .Net email libraries and it was consider a critical feature!  They just haven't done so or exposed it.  In the end we're stuck with these workarounds.

    Wednesday, February 27, 2013 9:01 PM