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

Database Mail not sending emails Expand / Collapse
Author
Message
Posted Saturday, August 24, 2013 6:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 11:33 AM
Points: 202, Visits: 1,056
Hi,

I am not able to send emails using database mail. can you please help me in fixing the issue.

Server : SQL SERVER 2008 R2 Enterprise Edition (64-bit)

Windows: Windows SERVER 2008 R2 Standard Edition (64-bit) SP1

I can see database mail started. I can see after feb 25,2013 the database emails stopped being getting delivered.

I am not posting columns from 17 to 233 under mailitem_id in email sent status as it would make the post larger. the data looks similar.


Mail Queues

queue_type length state last_empty_rowset_time last_activated_time
mail 228 INACTIVE 2013-08-24 20:22:12.787 2013-08-24 20:22:12.773
status 0 INACTIVE 2013-06-10 14:28:32.893 2013-06-10 14:28:32.893

--Email Sent Status

mailitem_id profile_id send_request_date sent_account_id sent_status sent_date last_mod_date
1 1 2/11/13 11:07 AM 1 sent 2/11/13 11:07 AM 2/11/13 11:07 AM
2 1 2/11/13 11:11 AM 1 sent 2/11/13 11:11 AM 2/11/13 11:11 AM
3 1 2/19/13 8:00 AM 1 sent 2/19/13 8:00 AM 2/19/13 8:00 AM
4 1 2/25/13 11:23 AM 1 sent 2/25/13 11:23 AM 2/25/13 11:23 AM
5 1 2/25/13 11:23 AM 1 sent 2/25/13 11:23 AM 2/25/13 11:23 AM
6 1 2/25/13 1:51 PM 1 sent 2/25/13 1:51 PM 2/25/13 1:51 PM
7 1 2/25/13 1:55 PM 1 sent 2/25/13 1:55 PM 2/25/13 1:55 PM
8 1 2/25/13 2:03 PM 1 sent 2/25/13 2:03 PM 2/25/13 2:03 PM
9 1 2/25/13 2:06 PM 1 sent 2/25/13 2:06 PM 2/25/13 2:06 PM
10 1 6/25/13 7:00 AM NULL unsent NULL 6/25/13 7:00 AM
11 1 6/25/13 7:15 AM NULL unsent NULL 6/25/13 7:15 AM
12 1 6/26/13 7:00 AM NULL unsent NULL 6/26/13 7:00 AM
13 1 7/8/13 9:00 AM NULL unsent NULL 7/8/13 9:00 AM
14 1 7/10/13 7:00 AM NULL unsent NULL 7/10/13 7:00 AM
15 1 7/12/13 10:00 AM NULL unsent NULL 7/12/13 10:00 AM
16 1 7/12/13 10:04 AM NULL unsent NULL 7/12/13 10:04 AM
234 1 8/24/13 6:39 AM NULL unsent NULL 8/24/13 6:39 AM
235 1 8/24/13 6:54 AM NULL unsent NULL 8/24/13 6:54 AM
236 1 8/24/13 7:09 AM NULL unsent NULL 8/24/13 7:09 AM
237 1 8/24/13 4:22 PM NULL unsent NULL 8/24/13 4:22 PM


Thank You,
Post #1488178
Posted Wednesday, August 28, 2013 8:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 11:33 AM
Points: 202, Visits: 1,056
Hi ,

I had found out the Issue. The security on the dotnet framework got messed up after the installation of the third party drivers on the server. To fix this issue, I had given the permissions to the SQL Server service accounts on machine.config file. Now the database mails are getting delivered.

Thank You
Post #1489245
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse