Post reply

Failure sending mail using Database Mail

  • May 5, 2010 at 5:25 am

    #220412

    Hi all,

    I'm trying to configure a profile for sending mails using Database Mail but always get the same result.

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2010-05-05T13:12:13). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )

    My remote mail server use SSL at 465/tcp port . I've created an VBS script to test the mail account from the same server where SQL 2008 is installed and it sends the test mail, but when I try to send a test mail using the "Send Test E-Mail" at the SSMS I get that error.

    Can someone give a clue?

    Thanks

  • May 10, 2010 at 10:54 pm

    #1165334

    sgo-964563 (5/5/2010)

    Hi all,

    I'm trying to configure a profile for sending mails using Database Mail but always get the same result.

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2010-05-05T13:12:13). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )

    My remote mail server use SSL at 465/tcp port . I've created an VBS script to test the mail account from the same server where SQL 2008 is installed and it sends the test mail, but when I try to send a test mail using the "Send Test E-Mail" at the SSMS I get that error.

    Can someone give a clue?

    Thanks

    Let's start with this, Can you post the result back from these:

    Have you enable the check mark on the Account setup to use SSL for SMTP?

    SELECT is_broker_enabled FROM sys.databases

    EXECUTE dbo.sysmail_help_status_sp

    EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'

  • May 12, 2010 at 3:00 am

    #1166021

    Hi,

    first of all I'll thank you for your reply.

    Yes, I have checked it and it doesn't work.

    At the moment I'm using a Gmail account but I prefer using a corporative one.

    Thanks

  • May 12, 2010 at 9:22 pm

    #1166609

    wat port number u using for gmail??

  • May 13, 2010 at 4:00 am

    #1166744

    For Gmail i'm using 587 and it works but my corporate SMTP uses 465 and it doesn't work 🙁

    I've made a VBS script to test my corporate mail using 465 and it works but using database mail it doesn't.... 🙁

    Thanks

  • May 13, 2010 at 4:36 am

    #1166753

    What in error log??

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

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