changed some Passwords, database mail seems to have stopped

  • davidandrews13

    SSCertifiable

    Points: 6660

    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.

  • anthony.green

    SSC Guru

    Points: 112212

    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?



    How to post data/code for the best help - Jeff Moden[/url]
    Need a string splitter, try this - Jeff Moden[/url]
    How to post performance problems - Gail Shaw[/url]
    Managing Transaction Logs - Gail Shaw[/url]
    Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]

  • davidandrews13

    SSCertifiable

    Points: 6660

    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 😎

  • anthony.green

    SSC Guru

    Points: 112212

    No worries, glad the issue is resolved.



    How to post data/code for the best help - Jeff Moden[/url]
    Need a string splitter, try this - Jeff Moden[/url]
    How to post performance problems - Gail Shaw[/url]
    Managing Transaction Logs - Gail Shaw[/url]
    Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply