Database mail

Question

Database mail

shanila_minnu

Hall of Fame

Points: 3465
More actions
May 18, 2009 at 7:08 am

#155720

I have configured database mail,but send test email is not working...in another sever i configured and it is working fine.In database mail log itis showing the following error
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2009-05-18T14:01:46). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it).
)

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

This is telling you that the mail server is rejecting your request to send email. Check firewall settings between the two servers, and then check to see if your SQL Server is authorized to relay through the mail server or if it requires additional configuration of your mail server to do so.

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 2

shanila_minnu

Hall of Fame

Points: 3465

May 18, 2009 at 8:08 am

#996348

how can we check the firewall settings

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

In addition to what Jonathan is recommending you should also check your anti-virus setting (if you have AV on your SQL Server). By default McAfee blocks Database mail through it's access protection setting, prevent mass mailing worms from sending mail. When this happens you get the error you listed. You need to add database mail (DatabaseMail90.exe) as an exception to the rule.

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

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 4

ya it is the problem of blocking....how can i resolve this...please help me

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

shanila_minnu (5/18/2009)
ya it is the problem of blocking....how can i resolve this...please help me

Jack Corbett (5/18/2009)
You need to add database mail (DatabaseMail90.exe) as an exception to the rule.

If you are using McAfee Enterprise and do not administer it, you need to have your McAfee administrator add it to the exceptions list for that rule.

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

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 6

In virus scan console=>Access protection =>prevent massmailing worm from sending mail=>in that i have to uncheck the options...am i right??????

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

Yes you could disable it that way, or you can go to that point and go into the rule's properties and add DatabaseMail90.exe to the exception list. As I said in one of my earlier posts, if you are using the Enterprise edition and have a central update server and policy you need to have the McAfee administrator add the exception to the policy, or any changes you make locally will be overwritten by the policy.

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

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 8

I am with Jack on this, it is better to allow by rule rather than allow for all when dealing with your firewall and anti-virus, worm prevention software.

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 9

jack..

Thanks for ur above update...but i dont know how to reach the "rule prperties"...please help

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 10

i am using standard edition of sql server 2005..also i need advise on task creat to clean databasemail history ........

Jack Corbett SSC Guru Points: 184394 More actions · Answer 11

As I said earlier, if you have McAfee Enterprise you need you McAfee administrator to make the changes or else they will be overwritten by policy.

You can change it on your own by going into VirusScan Console -> Double-Click on Access Protection -> Select the Anti-Virus Standard Protection Category -> Select the Prevent mass mailing worms from sending mail -> Click Edit -> Add DatabaseMail90.exe to the processes to exclude -> Click OK -> Click OK -> Exit VirusScan console by clicking the "X" In the upper right.

Again changing it locally will be overwritten by enterprise policy.

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

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 12

please advise how to create maintanence plan to clean databasemail history ........

Dugi SSCoach Points: 17998 More actions · Answer 13

shanila_minnu (5/22/2009)
please advise how to create maintanence plan to clean databasemail history ........

Try this:

http://www.sqlservercentral.com/Forums/FindPost721992.aspx

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

jts2013 Hall of Fame Points: 3226 More actions · Answer 14

Jack Corbett (5/18/2009)
In addition to what Jonathan is recommending you should also check your anti-virus setting (if you have AV on your SQL Server). By default McAfee blocks Database mail through it's access protection setting, prevent mass mailing worms from sending mail. When this happens you get the error you listed. You need to add database mail (DatabaseMail90.exe) as an exception to the rule.

I would recomend anyone to check their AV is not blocking port 25 as a starting point, as I have spent three weeks wondering why DB MAil would work on five servers, but not on two others. In the end I spotted a message from McAfee in the Application section of Event Viewer saying it had kindly blocked an outgoing email request 😉