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 |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2010-08-10 : 16:49:22
|
| Having trouble getting Database Mail to work on SQL 2008. I had no trouble getting it working on SQL 2005. I'm using the same smtp account on both servers. I am able to send a test mail fine on the SQL 2005 server.When I try and send a test email on SQL 2008 I get the following. MessageThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2010-08-10T16:44:05). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 66.84.51.92:25).I have followed the steps here on setting up the mail:http://www.codeproject.com/KB/database/SQLServer2008DatabaseMail.aspxNot sure if there is something else I may be missing. |
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2010-08-10 : 17:24:49
|
| I have also verified the user I am logged in as is a member of the DatabaseMailUserRole.One thing I have noticed is in the log it shows last modified by sa.Didn't know if that means anything or not. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-17 : 05:11:23
|
| I tried that as well just a few weeks back and was confused on what I did wrong. Finally it was down to the firewall. Check if the smtp port is opened for the sqlserver going to the mail server.Since the FW admin is away on vacation, I tested the procedure on my local sql server (since my workstation would have internet) and configured database mail to use gmail server :D...that worked pretty well...that's how i determined that the steps are ok.--------------------keeping it simple... |
|
|
|
|
|
|
Database Mail