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

Question

Post reply

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

MSQLDBA

SSCrazy

Points: 2783
More actions
July 22, 2010 at 12:55 am

#157097

Hi Friends,
I am going to configure the Database mail notification on my SQL Server 2005. I have configured it while i am going to send test mail i am getting an error message,
Date7/22/2010 12:17:48 PM
LogDatabase Mail (Database Mail Log)
Log ID53
Process ID1752
Mail Item ID16
Last Modified7/22/2010 12:17:48 PM
Last Modified Bysa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2010-07-22T12:17:48). Exception Message: Could not connect to mail server. (No such host is known).
)
pls help me out by this problem. I also checked my firwall there is also prot no. is not blocked. Still i m not getting messagges on my mail.
Thanks in Advance.
M.I.
________________________________________
M.I.
[font="Times New Roman"]
Learning is a path with no destination...
[/font]

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

okiftequar (7/22/2010)
Exception Message: Could not connect to mail server. (No such host is known).
)

that error is usually because the url to the mail server is incorrect, or there's no connectivity at all;

your setup should look something like this:

what is the value you put in for the server?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

MasterDB Hall of Fame Points: 3054 More actions · Answer 2

hi folks,

can anyone help regarding this issue which i've attached. some people are not receiving automated mails. But am able to send the test mail from the same profile..

TIA..

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

srinath.vanama (8/9/2011)
hi folks,
can anyone help regarding this issue which i've attached. some people are not receiving automated mails. But am able to send the test mail from the same profile..
TIA..

Please start a new thread after testing google. I'd bet a lot that it knows the answer to that one.

Lowell SSC Guru Points: 323518 More actions · Answer 4

the errors pretty straight forward, i think:

The specified string is not in the form required for an e-mail address
http://www.google.com/search?q=The+specified+string+is+not+in+the+form+required+for+an+e-mail+address&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1

you probably have an exchange server, and in the From Address of the profile you created, you have (for example) "srinath.vanama" instead of "srinath.vanama@yourdomain.com", so it works for some internal tests, as Exchange converts it to teh proper email, but not for external emails.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

manub22 Hall of Fame Points: 3163 More actions · Answer 5

Check my blog post where I've menitioned steps to configure Database Email

Link: http://sqlwithmanoj.com/2010/09/29/database-mail-setup-sql-server-2005/[/url]

Perform all steps mentioned in the blog post.

Also try out pointing your mail server to GMAIL, check if its working properly or not.

~manoj | LinkedIn | Facebook | YouTube
Blog: SQLwithManoj.com

seanjohns_dba Valued Member Points: 69 More actions · Answer 6

All, I am having the same issue. I have tried everything mentioned.

I am using gmail account. Server name = smtp.gmail.com

port number 465, Checked the check box "this server requires a secure connection".

Using basic authentication with my test email address and password. Getting error when sending test email:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2016-08-24T13:52:31). Exception Message: Cannot send mails to mail server. (Failure sending mail.).

Tried different port number (587) but get different error message:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2016-08-24T14:04:57). Exception Message: Could not connect to mail server. (An attempt was made to access a socket in a way forbidden by its access permissions 74.125.25.109:587).

btw using SQL server 2012.

Thanks,

Sean