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