June 25, 2009 at 4:13 pm
HI, I have configured three non-clsuter servers to use Database mail succesfully.Send Test mail ok, send mails with
msdb.dbo.sp_send_dbmail, without problems.
But when I configure Database mail in the nodes of my cluster system, and testing, Database mail never send the mails,
I always do same steps:
create account, configure SMTP server
create profile
test aparently send it but never deliver.
If I test with msdb.dbo.sp_send_dbmai, the result is : Mail queued, but never do the delivery.
Thanks for your help.
June 26, 2009 at 8:09 am
Have you verified that service broker is enabled in msdb?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 26, 2009 at 9:05 am
as said before check the broker status and also you can stop and start dmail and send again to check if it works....
Maninder
www.dbanation.com
June 26, 2009 at 11:33 am
Yes Jack, is enabled.
SELECT is_broker_enabled FROM sys.databases WHERE name = ‘msdb’;
is_broker_enabled
-----------------
1
(1 row(s) affected)
June 26, 2009 at 11:47 am
Mani, thanks, the broker is enable, but How must I do to stop and start the database mail service?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply