Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

changed some Passwords, database mail seems to have stopped Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2013 3:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 585, Visits: 3,434
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
Posted Tuesday, January 15, 2013 3:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:19 AM
Points: 5,216, Visits: 5,109
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
Posted Tuesday, January 15, 2013 3:50 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 585, Visits: 3,434
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
Post #1407141
Posted Tuesday, January 15, 2013 3:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:19 AM
Points: 5,216, Visits: 5,109
No worries, glad the issue is resolved.



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 #1407144
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse