Post reply

DB Mail

  • August 17, 2011 at 3:03 am

    #246368

    Hi All,

    I have configured a db mail in SQL Server 2005. I am trying to send the mails using that dbmail, but its not sending. What might be the reasons for this issue.

    also can you please let me know some trubleshooting steps for DB Mail.

    Thanks in advance.

    Thank You.

    Regards,
    Raghavender Chavva

  • August 17, 2011 at 4:04 am

    #1369486

    Check following link:

    http://technet.microsoft.com/en-us/library/ms187540.aspx

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • August 17, 2011 at 5:50 am

    #1369519

    msdb has some tables which contain the errors and their details.

    i create a view to make them eaiser to access, i think this might help you.

    i get errors like this:

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 92 (2010-04-20T13:27:59).

    Exception Message: Cannot send mails to mail server.

    (Mailbox unavailable. The server response was: 5.7.1 Requested action not taken: mailbox not available). )

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-03-03T08:42:29).

    Exception Message: Could not connect to mail server.

    (No connection could be made because the target machine actively refused it 209.190.184.120:825). )

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2011-05-04T09:42:55).

    Exception Message: Cannot send mails to mail server.

    (The specified string is not in the form required for an e-mail address.). )

    -- CREATE VIEW sp_FailMail

    -- AS

    SELECT DISTINCT

    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!

  • August 17, 2011 at 6:44 am

    #1369557

    Thanks Lowell.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • August 17, 2011 at 6:47 am

    #1369560

    Raghavender (8/17/2011)

    Hi All,

    I have configured a db mail in SQL Server 2005. I am trying to send the mails using that dbmail, but its not sending. What might be the reasons for this issue.

    also can you please let me know some trubleshooting steps for DB Mail.

    Thanks in advance.

    look the bottom of the post Basic checks while setup the DBmail.

    http://sqlserverblogforum.blogspot.com/2011/02/how-to-setup-database-mail-in-sql.html%5B/url%5D

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • August 17, 2011 at 7:13 am

    #1369578

    Try sending some Test mails. Then run the below query and post the results

    select * from msdb..sysmail_allitems

    Thanks and Regards

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

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