DBAMAIL for SQL Server 2005

Question

DBAMAIL for SQL Server 2005

Hollyz

SSCommitted

Points: 1763
More actions
August 14, 2006 at 12:18 pm

#113853

Hi,
I have setup DBAmail.
3 questions:
1. On the DBAMail configuration account, the New Database Mail Account screen, for the Outgoing Mail Server (SMTP),    It ask to specify the Email Address and the Reply email. Since it is a test box - which is located on my local box), the email I put is my own email address. For a production box, would that bee appropriate to put my own email address or which email address to put? What is does this Email Address and Reply email do anyway?

2. When I tested the DBAmail using the Database Engine Query, the @recipients field I have to type in the full email address: for example: ConnieW@Marriothotel.org   in order for it to be sent successfully. However, if I just sent as ConnieW it will generate an error message like this:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-14T14:03:20). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.). )
In sql 2000, when I do the
EXEC xp_sendmail
   @recipients = 'ConnieW',   the message goes through .
In the above example, ConnieW is a valid email account on the company's address (a valid internal email account on the company).
Somehow it is not resolving the name in DBAMail(sql 2005) but it is resolving in SQL Mail (sql server 2000)

3. Also if I try to sent (using DBAMail ) to a recipient that is not internal email account on the company like a ....@yahoo.com email, it won't go through either.
This is the message it'll generate:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-14T11:14:02). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: Relaying is prohibited). )
Anyone has an answer/solution/cause to anyone above question would help a great deal.

Viewing 4 posts - 1 through 3 (of 3 total)

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

William Versaskas SSC Eights! Points: 864 More actions · Answer 1

Before I begin, you are using DBMail not DBAMail. Now that has been addressed here are the answers to you questions.

1) eMail address is the address from where the message is being sent. It does not have to be a valid email address. The reply email address is the address that an email will go to in the event someone replys to the original email.

2) You need to use a fully qualified email address because DBMail uses SMTP and not MS exchange. The reason it works while executing xp_sendmail is because that is using MS exchange and the 'ConnieW' will get resolved via exchange.

3) The SMTP server DBMail is using needs to be configured to be able to send mail to outside clients.

Hope this helps!

Hollyz SSCommitted Points: 1763 More actions · Answer 2

Thanks s much for your answers to the point. You answered all my questions!!! It is clear now.

DBAsql-1046554 Ten Centuries Points: 1088 More actions · Answer 3

HI,

While configuring the DBMail i got the following error.

"The mail could not be sent to the recipients because of the mail server failure.

(Sending Mail using Account 2 (2009-03-23T23:14:07).

Exception Message: Could not connect to mail server.

(A connection attempt failed because the connected party did not properly respond

after a period of time, or established connection failed because connected host has failed

to respond). )"

Thanks in advance.