Database Mail sending email problem
Question
Wednesday, August 3, 2011 4:34 PM
Hi All, I am having a problem with Database Mail .
I created profile and Account and It is working fine in some servers but i am having problem in sending email in one of my sql server 2005 ..when ever i test to send an email : below errors throws up
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2011-08-03T10:28:42). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 205.209.32.250:25).
Log : Database Mail (Database Mail Log)
Last Modified By : sa
can anyone please help me on this
Thanks
All replies (7)
Monday, August 8, 2011 4:41 PM âś…Answered
Hi,
I would advise you to verify certain things and make changes to get this work:
1.Ensure your SMTP server is working.
2.Make sure port 25 is open in firewall.
3.Check if you can telnet your smtp server.
4.You may consider adding the aspnet_wp.exe to the exclusion list for sending email.
5.Be sure to check if McAfee Antivirus is installed on the server. By default, Access Protection blocks outgoing smtp connections, except for a whitelist of applications. This will result in the "No connection could be made because the target machine actively refused it" error message. Add w3wp.exe tot the whitelist of applications and everything will work fine.
Regards, Vishal Srivastava
Wednesday, August 3, 2011 5:29 PM
Database mail Test email is working but when a job fails sending the notification to operator fails
I enabled profile on on SQL server properties-Alert systems-,
the operator email is good
i am not understanding why iam not getting notification through sql server agent ?
can anyone please help me
Wednesday, August 3, 2011 7:04 PM
Hello,
From what it looks like either the local firewall or corporate firewall is blcoking the connection attempt to 205.209.32.250 port 25 (default smtp). Double check your firewall rules for both servers and possibly ask your networking team to run a trace to see where or what is causing it.
Also, it's generally not a good idea to post acutal IP addresses or internal names on public forums.
Hope this helps,
Sean
Wednesday, August 3, 2011 7:05 PM
This might be a duplicate thread from the one below, but if you are getting test emails out but not getting alerted, try restarting the sql server agent service.
-Sean
Wednesday, August 3, 2011 10:08 PM
Or check the permissions on the database mail profile; is it public? if not by default only sysadmin can send mails.Mohit K. Gupta MCTS, MCITP, MCC2011 http://sqllearnings.blogspot.com/
Wednesday, August 3, 2011 10:08 PM
check the communication of the mail server from to the DB server:
Telnet 205.209.32.250 25
Probably this you need to redifine the firewall rules.
Monday, August 8, 2011 3:51 PM
Troubleshooting database mail setup errors.
See the bottom of the post : Basic checks while setup the DBmail.
http://www.sqlserverblogforum.com/2011/02/how-to-setup-the-database-mail-in-sql-server-2005/
Muthukkumaran Kaliyamoorthy SQL DBA