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

Problems in Database mail in SQL server 2005 Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 3:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, July 19, 2014 7:02 AM
Points: 1,602, Visits: 1,571
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
Posted Wednesday, May 27, 2009 3:43 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:14 AM
Points: 1,530, Visits: 1,734
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
Posted Wednesday, May 27, 2009 3:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
i face similar issues...
Barry suggested me some alternative to check for proper settings.... i'm yet to do that...

May be u can test it too...

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







Pradeep Singh
Post #723909
Posted Wednesday, May 27, 2009 3:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, July 19, 2014 7:02 AM
Points: 1,602, Visits: 1,571
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
Posted Wednesday, May 27, 2009 4:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:14 AM
Points: 1,530, Visits: 1,734
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
Posted Wednesday, May 27, 2009 4:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, July 19, 2014 7:02 AM
Points: 1,602, Visits: 1,571
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
Posted Wednesday, May 27, 2009 4:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:14 AM
Points: 1,530, Visits: 1,734
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
Posted Friday, May 29, 2009 6:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, July 19, 2014 7:02 AM
Points: 1,602, Visits: 1,571
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 »

Add to briefcase

Permissions Expand / Collapse