Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rbarlow
Starting Member
26 Posts |
 Posted - 2010-02-15 : 20:03:30
|
| I'm trying to configure Database Mail on a new server and have configured it exactly as my other servers but it's not working. This is on a SQL Server 2008 Enterprise x64 instance.In the Database Mail logs, my test emails generate the following message:The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-02-15T16:58:54). Exception Message: Could not connect to mail server. (A non-recoverable error occurred during a database lookup). )I did a test by connecting to the SMTP server with telnet and sending a test email that way and it worked fine. Does anybody have any suggestions for troubleshooting? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 01:35:23
|
| have you configured SMTP as per belowhttp://support.microsoft.com/kb/304897also do you have any anti virus programs running? if yes, it blocks services from sending on TCP-25 (like an email worm). Adjust the anti virus software accordingly. Add DATABASEMAIL90.EXE to the list of allowable programs in your anti virus program------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-16 : 09:57:58
|
| Are the firewall ports open between the server and the mail server?Double check that any anti-virus isn't stopping the messages.Also, from the SQL Server try telnetting to the mail server to check a connection.type [telnet Server 25] (or whatever port it uses) from a command prompt. |
|
|
|
rbarlow
Starting Member
26 Posts |
Posted - 2010-02-17 : 11:27:21
|
| It turns out it was my own dumb mistake. I accidentally put a @ in the SMTP server's fully qualified name.smtpserver.domain.com <- rightsmtpserver@domain.com <- wrongGotta love Mondays... :-( |
|
|
|
|
|
|
Database Mail Not Working