SQL mail problems

Well, there are all sorts of problems you can face with your sql mail. Typically you'll test it out, it will work fine, you'll put it in an SP and it will fail on you. Here are some things to look at.

msdb.dbo.sp_send_dbmail

Make sure user is in correct group on msdb database (DatabaseMailUserRole)

If you get a mysterious error like this:

Set the mail account profile to public:

  • management\database mail

  • configure database mail

  • manage profile security

6 thoughts on “SQL mail problems

Leave a Reply

Your email address will not be published.