Send Mail using sql 2008r2

Question

Hai i can't send mail from sql 2008r2.but i create a prfile correct format. but mail status is Failed  .please give reason

snowal raj · Answer

Hi Prateek I try that link but same result was came and also reason for failed status is  The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2016-12-03T12:05:35). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )

Prateek Singla · Answer

Hi Snowal raj Please check these links for trouble shoot http://www.sqlservercentral.com/Forums/Topic1009158-146-1.aspx https://sqlserverposts.wordpress.com/2013/10/10/troubleshooting-db-mail-issues-in-sql-server/

snowal raj · Answer

Hi Prateek I already try this i got result in the table SYSMAIL_ALLITEMS but sent_status is failed and mail is not send to my client

Prateek Singla · Answer

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/ Please check this link