Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is there any way to verify that an email delivered by a data driven subscription has been received by a specific user? Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 4:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 2:53 PM
Points: 204, Visits: 1,246
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.
Post #1450822
Posted Wednesday, May 8, 2013 6:38 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 9:54 PM
Points: 727, Visits: 1,436
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
Post #1450855
Posted Thursday, May 9, 2013 7:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 2:53 PM
Points: 204, Visits: 1,246
I had a hunch that I was going to need to go this route. Thank you for the very practical advice.
Post #1451095
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse