Problems in Database mail in SQL server 2005

Question

Post reply

Problems in Database mail in SQL server 2005

Ryan007

SSCrazy Eights

Points: 8275
More actions
May 27, 2009 at 3:28 am

#131943

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//

Viewing 8 posts - 1 through 7 (of 7 total)

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

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

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

ps. One Orange Chip Points: 29422 More actions · Answer 2

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

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 3

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//

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 4

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

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 5

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//

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 6

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/

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 7

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//