Post reply

SSRS subscription - picking up network id instead of email address

  • April 19, 2016 at 11:33 am

    #325739

    Hi,

    SSRS subscription - picking up network id instead of email address

    http://www.sqlservercentral.com/Forums/Attachment18793.aspx

    Basically in "To:" it should pick up abc@email.com for that user (network id: networkid123)

    How to change the default config setting.

    Thanks in advance.

    Regards,

    Monil

  • June 15, 2016 at 11:29 am

    #1885225

    set this line as below :

    SendEmailToUserAlias>False</SendEmailToUserAlias>

  • June 20, 2016 at 1:18 pm

    #1885910

    It didn't work as intended. It is now coming as blank (nothing) field.

    It is not picking up email address.

  • June 20, 2016 at 2:14 pm

    #1885917

    You can't have SSRS default to an exchange alias. It uses the alias against the AD account. Changing that setting to false opens up the to box to allow users to enter an email address. If set to true then standard uses can't enter anything in the to line - it defaults to their alias.

    If you have SendEmailToUserAlias set to false you can use the permitted hosts config to limit where the emails can be sent to.

  • June 20, 2016 at 4:02 pm

    #1885928

    @SSC-Addicted- Then how to default to email address for that AD alias?

    For Example: Username: <domain-name>\<network-id> (dnid123)

    Now when I click on subscribe then it picks up as SendTo="nid123" but I want it as <firstname>.<lastname>@<domain-name>.com (firstname.lastname@domain.com)

    So is there any AD setting I need to do?

    Thanks for your responses.

Viewing 5 posts - 1 through 4 (of 4 total)

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