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

  • 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]

  • 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!

  • 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..

  • 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.

  • 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!

  • 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.

  • 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

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

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