problem with Database mail
We have SQL SERVER 2008 R2,which Database mail does not work properly.When I try to send test mail,it says it has been queued but it does not being delivered. Here are some point about about Database mail configuration 1- Database mail is enabled. 3- database mail is started 4- the status of mail queue is "InActive" 5- The size of mail queue is 9025 and status is Inactive and the status queue is empty(length is 0) and it has been actived a long time ago. 6- service Broker is enabled. 7- When I ran the databasemail.exe manually nothing happened. 8- In mail log shows only The mail queue was started or stopped and it does not show any failure or problem. 9- also the status all mail in sysmail_allitems table is 'unsent' Note : I have one Profile and one account in that profile. I wil be grateful,if someone help me on this. Thanks Aspet A.G
March 3rd, 2013 12:21am

Hi, I just tried as shown in the link ,it worked for me - http://sathyadb.blogspot.in/2013/02/sql-server-database-mail.htmlThanks & Regards, sathya
Free Windows Admin Tool Kit Click here and download it now
March 7th, 2013 3:34pm

I have already setup mail configuration in all of our production servers(around 20) and all oif them are fine ,excpet one of them has that problem. Any help will be appreciated.A.G
March 7th, 2013 8:05pm

Hi A.G, Here is a official article about troubleshooting Mail queued, not delivered problem: http://msdn.microsoft.com/en-us/library/ms190630(v=sql.105).aspx Please run this query first: sp_CONFIGURE 'show advanced', 1 GO RECONFIGURE GO sp_CONFIGURE 'Database Mail XPs', 1 GO RECONFIGURE GO After checking the link above and running the above query, if the problem still there, please re-create the profile, and try to send the test mail using SP_send_dbmail: USE msdb GO EXEC sp_send_dbmail @profile_name='', @recipients='', @subject='', @body='' Also, please ensure the port of database mail is open in your machine, the default port for database mail is 25.Iric Wen TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
March 8th, 2013 11:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics