Post reply

problem in Data driven subscription

  • November 2, 2010 at 4:16 am

    #1245255

    Any reply please...

  • November 2, 2010 at 8:27 am

    #1245422

    Sorry, I have been getting nailed in my email lately and missed your response.

    The configuration that I was talking about is in the Reporting Services Configuration Manager. However, if you are using GMAIL as your smtp, there are other settings that have to be changed that are not in the configuration manager. You'll need to edit the .config file settings.

    To help you out, I just did a quick query on Google for "configure ssrs to use gmail smtp":

    http://www.google.com/#sclient=psy&hl=en&site=&source=hp&q=configure+ssrs+to+use+gmail+smtp&aq=f&aqi=&aql=&oq=&gs_rfai=CYwwZoh7QTJX9NYr0zQSf-tXlDwAAAKoEBU_QmXRp&psj=1&fp=c096fadce09e306f

    I personally have not tried to use gmail as an smtp server, so I can't help you with that. I will try tonight if I have some free time, but you may want to read this:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/49fd92b9-810d-4a2c-af18-a63fbf6e1a46

    It says that you'll need to install a local smtp server and configure it to basically forward to smtp.gmail.com.

    I hope this helps.

    Brian

    Brian K. McDonald, MCDBA, MCSD
    Business Intelligence Consultant
    Jacksonville, Florida

  • November 3, 2010 at 11:35 pm

    #1246388

    Brian K. McDonald (11/2/2010)

    Sorry, I have been getting nailed in my email lately and missed your response.

    The configuration that I was talking about is in the Reporting Services Configuration Manager. However, if you are using GMAIL as your smtp, there are other settings that have to be changed that are not in the configuration manager. You'll need to edit the .config file settings.

    To help you out, I just did a quick query on Google for "configure ssrs to use gmail smtp":

    http://www.google.com/#sclient=psy&hl=en&site=&source=hp&q=configure+ssrs+to+use+gmail+smtp&aq=f&aqi=&aql=&oq=&gs_rfai=CYwwZoh7QTJX9NYr0zQSf-tXlDwAAAKoEBU_QmXRp&psj=1&fp=c096fadce09e306f

    I personally have not tried to use gmail as an smtp server, so I can't help you with that. I will try tonight if I have some free time, but you may want to read this:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/49fd92b9-810d-4a2c-af18-a63fbf6e1a46

    It says that you'll need to install a local smtp server and configure it to basically forward to smtp.gmail.com.

    I hope this helps.

    Brian

    hi Thks for ur xtended help !

    i did it...

    now the mails started delivering to any of the internal mail ids, but not to any of the external mail ids...

    do any one have idea abt this??

  • November 8, 2010 at 1:43 am

    #1247531

    Hi All... it s been fixed.

    Instead of SMTP Name, when replaced with the IP address, it started mailing to external mail id too..

    Thanks for all who tried helping me..!!!

  • November 8, 2010 at 5:23 am

    #1247590

    Awesome! That's great news! Would you mind posting what your config file looks like now that it is running? That way others can see how you were able to resolve it?

    Thanks.

    Brian K. McDonald, MCDBA, MCSD
    Business Intelligence Consultant
    Jacksonville, Florida

  • November 8, 2010 at 5:30 am

    #1247596

    Brian K. McDonald (11/8/2010)

    Awesome! That's great news! Would you mind posting what your config file looks like now that it is running? That way others can see how you were able to resolve it?

    Thanks.

    Sure, it s like the following

    <RSEmailDPConfiguration>

    <SMTPServer>IP address</SMTPServer>

    <SMTPServerPort>25

    </SMTPServerPort>

    <SMTPAccountName>

    </SMTPAccountName>

    <SMTPConnectionTimeout>

    </SMTPConnectionTimeout>

    <SMTPServerPickupDirectory>C:\Inetpub\mailroot\Pickup</SMTPServerPickupDirectory>

    <SMTPUseSSL></SMTPUseSSL>

    <SendUsing>2</SendUsing>

    <SMTPAuthenticate>

    </SMTPAuthenticate>

    <From>mymailid@domain.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>

    actually in the above i dont think the pickupdirectory must be mentioned, anyhow, as mailing is working after long struggle i dont want to altered tht setup.:hehe:

    :O)

  • November 8, 2010 at 7:01 am

    #1247641

    Thanks for posting that. Just for clarification though... when you say you changed the IP Address, this section right here has the actual IP address of the SMTP server? Which in this case would be GOOGLE.com or is this a local server?

    <SMTPServer>IP address</SMTPServer>

    Thanks,

    Brian

    Brian K. McDonald, MCDBA, MCSD
    Business Intelligence Consultant
    Jacksonville, Florida

  • November 9, 2010 at 4:05 am

    #1248132

    Brian K. McDonald (11/8/2010)

    Thanks for posting that. Just for clarification though... when you say you changed the IP Address, this section right here has the actual IP address of the SMTP server? Which in this case would be GOOGLE.com or is this a local server?

    <SMTPServer>IP address</SMTPServer>

    Thanks,

    Brian

    Yes, but not the server name is not like google.com instead its ip adres in numbers like 123.456.789.10

    i gave the local smtp's IP address.

    Hope i clarified ;o)

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply