Post reply

Why can't I email subscriptions in Report Manager?

  • June 12, 2009 at 2:53 am

    #201387

    Part email naivety, part SQL naivety.

    We're running SQL 2008 under Server 2008. When users try to subscribe to a report via email in Report Manager, their email adress that Reporting Services defaults to is their network log in account.

    So if I have a john smith with a network login of jsmith but an email address of John.Smith@x.com, the email address that RS tries to send to is jsmith as opposed to something recognised by the exchange server.

    I've seen the Microsoft advice about populating a default domain in the config file, but that results in an email of jsmith@x.com which isn't a real email (and proves undeliverable).

    If I type jsmith directly into Outlook it resolves Ok as john.smith@x.com. What do I need to change for RS to handle this lookup?

    (The level of access that most users have prevents them from tpying in an email address so they have to accept Report Manger's default offering)

    Thanks,

    Andrew

  • June 13, 2009 at 3:35 pm

    #1009177

    I don't think Outlook is relevant because it is a client, you could use your local IIS SMTP as a relay to your Exchange server. I think the current documentation have covered most of the known issues like SSRS permissions in the SMPT server and other issues that stops mail delivery.

    http://msdn.microsoft.com/en-us/library/ms345234.aspx

    http://msdn.microsoft.com/en-us/library/ms159155.aspx

    Kind regards,
    Gift Peddie

  • June 18, 2009 at 4:00 am

    #1011585

    Thanks for the links. They haven't solved my problem but did lead me to a config setting that allows me to allow users to type in an email address.

    This workaround should be sufficient.

    Thanks,

    Andrew

Viewing 3 posts - 1 through 2 (of 2 total)

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