Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database mail Expand / Collapse
Author
Message
Posted Monday, May 18, 2009 7:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499

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).
)
Post #719022
Posted Monday, May 18, 2009 7:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 1:10 PM
Points: 1,708, Visits: 1,793
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.

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #719033
Posted Monday, May 18, 2009 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499
how can we check the firewall settings
Post #719085
Posted Monday, May 18, 2009 8:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 11,316, Visits: 13,105
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #719089
Posted Monday, May 18, 2009 8:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499
ya it is the problem of blocking....how can i resolve this...please help me
Post #719144
Posted Monday, May 18, 2009 9:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 11,316, Visits: 13,105
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #719153
Posted Tuesday, May 19, 2009 3:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499
In virus scan console=>Access protection =>prevent massmailing worm from sending mail=>in that i have to uncheck the options...am i right??????
Post #719615
Posted Tuesday, May 19, 2009 5:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 11,316, Visits: 13,105
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #719659
Posted Tuesday, May 19, 2009 6:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 1:10 PM
Points: 1,708, Visits: 1,793
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.

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #719724
Posted Thursday, May 21, 2009 8:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499


jack..

Thanks for ur above update...but i dont know how to reach the "rule prperties"...please help
Post #721405
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse