Post reply

How do I troubleshoot Database Mail?

  • January 5, 2015 at 11:47 am

    #1767843

    KenpoDBA (1/5/2015)

    Quite often in companies, they deny servers the ability of servers to use exchange as a relay server. You have to ask your email admin to add your sql box to the relay list.

    If everything else checks out this is my best guess.

    It's been a while since I've had to request it, but I believe the wording would be something like:

    Could you add my sql box (server1) to the list to be able to use exchange as a mail relay?

    Even internally in my lab here it took me 2 days to remember that and once I did, I added it to the list and was able to send mail immediately.

    For me biggest issue here is lack of details about the error. Issues like that (relay denies, wrong FROM address etc) shall be reflected in error message along with SMTP status code which is the case in majority of the issues I saw so far but in this case it just says "failure" which is completely useless for troubleshooting.

  • January 5, 2015 at 11:54 am

    #1767845

    That's why I suspected it may be a relay issue.

    Talk to your exchange guy.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

Viewing 2 posts - 16 through 16 (of 16 total)

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