SOLVED: Cannot Send Email From SQL Database Mail Even Though The Account is Setup

If your SQL applications can’t send email using database mail (I assume you already have DBMail Account and Profile setup), there are two things to set:

  1. SQL MANAGEMENT STUDIO > MANAGEMENT > DATABASE MAIL > right click and select CONFIGURE… > select MANAGE PROFILE SECURITY >
    1. put a check on PUBLIC option
    2. click on DEFAULT PROFILE (Yes, I know it does not appear to be clickable… but it is) and set it to YES
  2. SQL MANAGEMENT STUDIO > DATABASES > SYSTEM DATABASES > right click on MSDB and select NEW QUERY > then enter > grant execute on sp_send_dbmail to public and click OK

In my case I was seeing errors like:

The EXECUTE permission was denied on the object ‘sp_send_dbmail’, database ‘msdb’, schema ‘dbo’.

So the fix, or at least the root cause was more obivous than some errors.

This was the same in SQL 2008, R2 and I just had to run through this again in SQL 2012.

Thanks to Darren from www.NeoSystems.com for his fine assistance with this fix.

Comments

  1. Avatar
    Tony August 23, 2019 at 12:55 am

    Thanks

  2. Avatar
    Naveen June 1, 2018 at 4:14 am

    It is really helpful for me.

  3. Avatar
    Eder Jimenez Garcia September 23, 2014 at 11:42 am

    I can solved this error whith this script… thank you. You can not imaginate how much it help me…. best regards

Leave a Reply