October 14, 2008 at 1:12 am
I have set up database mail and it worked fine. But suddenly it stopped performing. I have checked all setting and everything seems configured propery. when i send test mail no message appears as "Database Mail Process Started" in database mail log viewer. And i receive no mails. My sql server is running under service account .\Administrator. Can somebody help.Thanx in advance.
October 14, 2008 at 4:40 am
Hi,
Database Mail makes use of SMTP mail server to send the mails. Make sure you have access to the SMTP mail server. Then you need to use this server name while configuring DB mail. If the access is fine, the mail send will work fine.
Check this out & let me know.
Have a nice day !!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 14, 2008 at 10:23 pm
Thanx for your cooperation.But How can i check i have access to smtp mail server.
October 15, 2008 at 5:12 am
Hi,
You need to provide the server name to your System Administrator and check if they have given access to SMTP server for your IP. If not then get the access .
Have a nice Day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 16, 2008 at 2:42 am
The problem may be further down the line than the SMTP relay server. If your server's IP is not in the authorised relay list on the SMTP server you would receive a database mail log entry saying ...A connection could not be made because the target machine actively refused it...
Or if the SMTP (relay) server was down, or someone changed its name, there would be a log entry saying ...Could not connect to mail server...
Either way, there will be a log entry!
October 16, 2008 at 3:33 am
I managed to fail to send an email and not get a log entry by using an invalid email address (same result with invalid user name and for invalid domain name).
Has the destination email account been renamed, deleted or disabled.
Or has it reached its mailbox limit?
October 16, 2008 at 9:18 am
Simple way to verify you can talk with the local SMTP mailserver is to use telnet from a CMD window:
telnet (mailserver) 25
You will either get a 220 success, along with details of the SMTP server, or a failure with details of what is wrong.
Andy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply