database mail Error

  • Hi

    I have set up database mail.

    I know the settings are correct because I use the same ones for MS Outlook on the same machine.

    I am getting the following error.

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T15:35:06). Exception Message: Cannot send mails to mail server. (Authentication failed.).

    )

    than you

  • wissam ismail (1/12/2012)


    Hi

    I have set up database mail.

    I know the settings are correct because I use the same ones for MS Outlook on the same machine.

    I am getting the following error.

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T15:35:06). Exception Message: Cannot send mails to mail server. (Authentication failed.).

    )

    than you

    Authentication failed means your mails erver requires a username and password to send an email...you cannot leave it blank.

    look at the profile you created,and edit the section near the bottom to have"basic authentication" selected, it so that it has the username and password:

    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,

    I already did exactly same as the above image, and I'm getting Error

    regards,

  • wierd; you are getting the same error as before when you look in failed items?

    SELECT

    err.[description],

    fail.*

    FROM [msdb].[dbo].[sysmail_event_log] err

    inner join [msdb].[dbo].[sysmail_faileditems] fail

    ON err.mailitem_id = fail.mailitem_id

    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!

  • yes...

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T09:45:41). 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 63.251.171.81:25). )

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T09:48:47). 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 63.251.171.81:25). )

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T10:11:35). 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 63.251.171.81:25). )

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T10:14:41). 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 63.251.171.81:25). )

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-01-12T10:22:05). 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 63.251.171.81:25). )

  • also, doublec check which email address you are using.

    i know, for exmaple, from one of my mail servers, my from address must be the same as the email address realted to teh account:

    so if my account thinks lowell@somedomain.com uses a specific username/password pair, i cannot send emails imersonating "support@anotherdomain.com" and supply those other specific credentials. it's some anti-spam thing, i think.

    that can vary depending on your mail server, but take that into consideration too.

    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,

    I added the configuration same as I tested it and worked on outlook!

  • wissam ismail (1/12/2012)


    hi,

    I added the configuration same as I tested it and worked on outlook!

    sweet! i was just about to post something about "Could not connect to mail server." and saw you got it working! congrats!

    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!

  • it worked on outlook, but not on SQL database Mail :angry:

  • A common issue with Database Mail is that it is blocked by anti-virus/anti-malware programs, http://wiseman-wiseguy.blogspot.com/2009/07/mystery-of-failing-database-mail.html. You should also check that smtp is opon on the firewall as outlook uses MAPI and database mail uses SMTP.

    Have you tried using GMAIL or HOTMAIL with database mail to see if that works?

  • wissam ismail (1/12/2012)


    it worked on outlook, but not on SQL database Mail :angry:

    oops spoke too soon then.

    Jacks suggestion on checking the firewall is the first thing to check.

    if that is opened up, check the web page athttp://www.mxtoolbox.com/

    and make sure the value you have for the mail server is really the right one for the domain.

    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,

    I turned off the firewall on windows, I got the same error

  • can you show a screenshot of your dbmail profile you created? that might give us some more information.

    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!

  • Kindly find attached a screenshot of my configuration

  • Afaik, database mail only support smtp. Can you try to telnet your mail server from your sql server to see if you get a response.

    telnet yourserver 25

Viewing 15 posts - 1 through 15 (of 17 total)

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