Home Forums SQL Server 2012 SQL 2012 - General Execute permission was denied on the object SP_SEND_DBMAIL RE: Execute permission was denied on the object SP_SEND_DBMAIL

  • February 19, 2013 at 2:17 am

    #1589074

    Firstly, Can you check if dbmail is enable in sys.configurations.

    BOL: "Execute permissions for sp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database. However, when the user sending the message does not have permission to use the profile for the request, sp_send_dbmail returns an error and does not send the message."

    eyespi20 (2/18/2013)

    We moved our production databases from an SQL2008R2 Standard Edition to SQL2012 Enterprise edition this past weekend. I have a DBMailUserRole defined in MSDB that has the execute rights to the sp_send_dbmail stored procedure and the user that is attempting to execute the sp is a member of the role, but I'm still getting this error.

    Anyone have any idea what I need to do in order to get this working?

    Thanks!

    Thanks
    Jagan K