Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The mail could not be sent to the recipients because of the mail server failure. Expand / Collapse
Author
Message
Posted Thursday, July 22, 2010 12:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 5, 2015 2:01 AM
Points: 134, Visits: 574
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,

Date 7/22/2010 12:17:48 PM
Log Database Mail (Database Mail Log)

Log ID 53
Process ID 1752
Mail Item ID 16
Last Modified 7/22/2010 12:17:48 PM
Last Modified By sa

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.

Learning is a path with no destination...

Post #956956
Posted Thursday, July 22, 2010 5:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 14,460, Visits: 37,994
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!
Post #957079
Posted Tuesday, August 9, 2011 6:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 24, 2016 1:09 AM
Points: 348, Visits: 572
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..


  Post Attachments 
DBMAIL.png (134 views, 52.42 KB)
Post #1156798
Posted Tuesday, August 9, 2011 7:05 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, April 13, 2016 12:23 AM
Points: 20,643, Visits: 9,671
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.
Post #1156808
Posted Tuesday, August 9, 2011 7:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 14,460, Visits: 37,994
the errors pretty straight forward, i think:


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!
Post #1156837
Posted Wednesday, August 10, 2011 3:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 26, 2016 1:17 AM
Points: 132, Visits: 1,698
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/

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
Post #1157466
Posted Wednesday, August 24, 2016 1:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 26, 2016 2:08 PM
Points: 1, Visits: 7
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



Post #1812181
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse