January 29, 2010 at 4:09 am
Hi All,
I have configured Database mail in one our servers. Everything is fine, the final step of the wizard shows "success". But I don't receive the test mail. Also, in "View Database Mail Log" it shows "Activation failure".
BTW the Dbs are hosted on a cluster. I have configured DB mail with the same profile settings on another cluster and it worked fine, don't know why it's not working here!!
Please give me a clue.
Thanks
January 29, 2010 at 9:56 am
Is Service Broker enabled in msdb?
SELECT is_broker_enabled FROM sys.databases AS D WHERE name = 'msdb'
Should return 1.
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
February 1, 2010 at 11:39 am
Thanks for the reply. Yes, service broker is enabled. The output of the query is 1
February 2, 2010 at 7:55 am
I've found a couple of instances where this was caused by an error in the installation of SP2. SP2 reports it succeeded, but there are a couple of scripts that failed.
Check out these links:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/2114d7d1-1fb6-448c-9757-16622631ed72 - down near the bottom of the thread.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply