changed some Passwords, database mail seems to have stopped

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Notification Services » Administration » changed some Passwords, database mail seems...

changed some Passwords, database mail seems to have stopped

Rate Topic

Display Mode

Topic Options

Author

Message

davidandrews13

Posted Tuesday, January 15, 2013 3:12 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:08 AM
Points: 457, Visits: 2,677

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.

Post #1407122

anthony.green

Posted Tuesday, January 15, 2013 3:16 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407125

davidandrews13

Posted Tuesday, January 15, 2013 3:50 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:08 AM
Points: 457, Visits: 2,677

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 :D

all i did was to update a password in one of the database objects.

thanks for your reply. much appreciated Cool

Post #1407141

anthony.green

Posted Tuesday, January 15, 2013 3:53 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

No worries, glad the issue is resolved.

Post #1407144

« Prev Topic | Next Topic »

Permissions