August 24, 2013 at 6:05 pm
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_typelengthstate last_empty_rowset_timelast_activated_time
mail 228 INACTIVE2013-08-24 20:22:12.7872013-08-24 20:22:12.773
status 0 INACTIVE2013-06-10 14:28:32.8932013-06-10 14:28:32.893
--Email Sent Status
mailitem_idprofile_id send_request_datesent_account_idsent_statussent_date last_mod_date
1 1 2/11/13 11:07 AM1 sent 2/11/13 11:07 AM 2/11/13 11:07 AM
2 1 2/11/13 11:11 AM1 sent 2/11/13 11:11 AM 2/11/13 11:11 AM
3 1 2/19/13 8:00 AM1 sent 2/19/13 8:00 AM 2/19/13 8:00 AM
4 1 2/25/13 11:23 AM1 sent 2/25/13 11:23 AM 2/25/13 11:23 AM
5 1 2/25/13 11:23 AM1 sent 2/25/13 11:23 AM 2/25/13 11:23 AM
6 1 2/25/13 1:51 PM1 sent 2/25/13 1:51 PM 2/25/13 1:51 PM
7 1 2/25/13 1:55 PM1 sent 2/25/13 1:55 PM 2/25/13 1:55 PM
8 1 2/25/13 2:03 PM1 sent 2/25/13 2:03 PM 2/25/13 2:03 PM
9 1 2/25/13 2:06 PM1 sent 2/25/13 2:06 PM 2/25/13 2:06 PM
10 1 6/25/13 7:00 AMNULL unsentNULL 6/25/13 7:00 AM
11 1 6/25/13 7:15 AMNULL unsentNULL 6/25/13 7:15 AM
12 1 6/26/13 7:00 AMNULL unsentNULL 6/26/13 7:00 AM
13 1 7/8/13 9:00 AMNULL unsentNULL 7/8/13 9:00 AM
14 1 7/10/13 7:00 AMNULL unsentNULL 7/10/13 7:00 AM
15 1 7/12/13 10:00 AMNULL unsentNULL 7/12/13 10:00 AM
16 1 7/12/13 10:04 AMNULL unsentNULL 7/12/13 10:04 AM
234 1 8/24/13 6:39 AMNULL unsentNULL 8/24/13 6:39 AM
235 1 8/24/13 6:54 AMNULL unsentNULL 8/24/13 6:54 AM
236 1 8/24/13 7:09 AMNULL unsentNULL 8/24/13 7:09 AM
237 1 8/24/13 4:22 PMNULL unsentNULL 8/24/13 4:22 PM
Thank You,
August 28, 2013 at 8:11 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply