Post reply

Is there any way to verify that an email delivered by a data driven subscription has been received by a specific user?

  • May 8, 2013 at 4:11 pm

    #277361

    Hello

    We are using a data driven subscription (SQL 2008 R2) to email recipient specific data to an exchange server in an external domain.

    All of the users but one say they receive their emails just fine.

    We confirmed that we have proper email address information for the user in question and that the report runs fine when you manually specify that user. There are no error reported by the subscription itself. They also say that email filters are not the issue.

    Is there any way to verify that an email delivered by a data driven subscription has been received by a specific user in an external domain?

    Thanks in advance for any advice.

  • May 8, 2013 at 6:38 pm

    #1613584

    The database isn't a mail server, so it has no way to register if someone received an email.

    Your two best bets would be

    1) Contact your network admin and have him review the email logs to see if it is getting blocked, etc. This should be pretty easy for them to do (well it is for my network guys, but it might be dependent upon mail configuration and such).

    2) Check the Reporting Service logs to see if there is a message telling that it failed for some reason. These logs are a bit different than the SQL Logs and Mail logs and often contain additional information.

    Generally speak, the ssrs logs are found her: %ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

  • May 9, 2013 at 7:02 am

    #1613775

    I had a hunch that I was going to need to go this route. Thank you for the very practical advice.

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

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