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 22, 2013 at 10:18 am

    #1590439

    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!

    Does the user have a default profile associated ?

    Can you post output of below queries and verify if the environment is clustered or not ?

    SELECT * FROM msdb.dbo.sysmail_sentitems order by sent_date desc

    SELECT * FROM msdb.dbo.sysmail_allitems order by sent_date desc

    SELECT * FROM msdb.dbo.sysmail_event_log order by log_date desc

    SELECT * FROM msdb.dbo.sysmail_unsentitems

    select * from msdb.dbo.sysmail_configuration

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂