MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1438

I have configured the settings what you told. When i tested the test mail the following error message is getting displayed in the log file.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2008-04-24T18:55:18). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ravikoppula1@gmail.com).
)

Can you please suggest a solution.

I tried wether smtp connection is working or not. It's working.

Hi ravi1217,

 are you sure, that you choose the right smtp authentication? plz. tell us your configuration.

ravi1217:

I have configured the settings what you told. When i tested the test mail the following error message is getting displayed in the log file.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2008-04-24T18:55:18). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ravikoppula1@gmail.com).
)

Can you please suggest a solution.

I tried wether smtp connection is working or not. It's working.

Hi,

 On http://www.databasejournal.com/features/mssql/article.php/3626056 (a similar run through of how to set up database mail), an error was displayed that is similar to yours and shows how to solve it.  The error shown is about half way down the page, and the solution given is to open up port 25 to allow emails to be sent.

 HTH