Problems in Database mail in SQL server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Problems in Database mail in SQL server 2005

Problems in Database mail in SQL server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Ryan007

Posted Wednesday, May 27, 2009 3:28 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:43 AM
Points: 1,564, Visits: 1,488

Hi,
Could you please help me in the below issue?

I have configured Database mail in SQL server 2005. But not able to send mail. I am getting the error as per the log file
'' The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-05-27T09:22:39). Exception Message: Cannot send mails to mail server. (Command not implemented. The server response was: Error: command not implemented)''
Do you have any idea to troubleshoot this problem?

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Post #723897

sql_lock

Posted Wednesday, May 27, 2009 3:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 1,289, Visits: 1,533

Hi

Have you enabled dbmail within Surface Area config?

Also how have you defined your smtp server, I have had in the past where "in some instances" you need to fully qualify the server name i.e. servername.domainname.com.

I found the artical below when i first had this issue (good job I backup my fav's)
http://www.tek-tips.com/viewthread.cfm?qid=1263518&page=22

Post #723905

ps.

Posted Wednesday, May 27, 2009 3:46 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620

i face similar issues...
Barry suggested me some alternative to check for proper settings.... i'm yet to do that... Doze

May be u can test it too...

http://www.sqlservercentral.com/Forums/Topic722842-146-1.aspx

Pradeep Singh

Post #723909

Ryan007

Posted Wednesday, May 27, 2009 3:51 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:43 AM
Points: 1,564, Visits: 1,488

Hi,
I have enabled database mail in SAC tool and SMTP server is put as you described. Using the same SMTP server, I am able to send mail from other server. The mail is in que but not getting delivered.

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Post #723912

sql_lock

Posted Wednesday, May 27, 2009 4:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 1,289, Visits: 1,533

Can you telnet to the smtp server from the SQL server

telnet server.domain.com 25
helo" enter
mail from: your Email Address enter
rcpt to:"recipient address" enter
data enter
enter . enter

Post #723921

Ryan007

Posted Wednesday, May 27, 2009 4:17 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:43 AM
Points: 1,564, Visits: 1,488

Hi,
From the server I have given the telnet command and found the below message.

220 ***************

Please let me know is it correct?

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Post #723931

sql_lock

Posted Wednesday, May 27, 2009 4:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 1,289, Visits: 1,533

220 is just that a connection has been made.

You need to try sending a mail. This will test relaying and a SMTP send.

http://www.amset.info/exchange/telnet-test.asp

If you can do this download the tool below
http://smtptester.codeplex.com/

Post #723935

Ryan007

Posted Friday, May 29, 2009 6:28 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:43 AM
Points: 1,564, Visits: 1,488

Hi,
Through SMTP command I am able to send message from that server. But not through database mail. Anything to check? Is it due to the access problem?

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Post #725739

« Prev Topic | Next Topic »

Permissions