January 15, 2013 at 3:12 am
i've seen there's a few threads about database mail, here, but none seem to apply to me.
I've changed a couple of system Passwords and have gone through the process of ensuring that all our processes work.
all but the database mail are, but now i'm stuck.
the passwords that have changed are for SA (not sure if database mail is using this account)
and a windows account (its more than likely using this one).
from SSMS, i right clicked the Database Mail node from the Management folder and chose to send a Test EMail but nothing has come through.
I've also viewed the Database Mail Log and there are lots of errors stating:
the mail could not be sent to the recipients because of the mail server failure... The server response was: Timeout
what i've done so far:
after changing the passwords, i logged onto the server and restarted the Sql Server Agent.
I've right clicked Database Mail from SSMS and selected Configure Database Mail.
I've then selected to 'Manage Database Mail accounts' and also 'Manage profile security' but neither sections explicitly mention a password that i wish it to connect with.
January 15, 2013 at 3:16 am
Whats the SMTP authentication mode for the account in the DB Mail config screen?
Windows Auth
Basic Auth
Anony Auth
Timeout would indicate that there is a problem in the connection, can the server ping the SMTP server ok?
Telnet over port 25 works ok?
January 15, 2013 at 3:50 am
hi.
its set to Anonymous Authentication.
i've actually got it to work, now.
i got it to work at 9:30 (about 45 minutes before i opened this thread), but the person who receives the emails didn't inform me, so i was still working away 😀
all i did was to update a password in one of the database objects.
thanks for your reply. much appreciated 😎
January 15, 2013 at 3:53 am
No worries, glad the issue is resolved.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply