SQLServerCentral / SQL Server 2012 / SQL 2012 - General / Execute permission was denied on the object SP_SEND_DBMAIL / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 09:15:08 GMT20RE: Execute permission was denied on the object SP_SEND_DBMAILhttp://www.sqlservercentral.com/Forums/Topic1421304-2799-1.aspxDid you also hook up the mail profile in sqlagent's Alert system tab. I don't think this will have any impact on using dbmail through a procedure. But, worth a tryFri, 22 Feb 2013 10:22:56 GMTjvkondapalliRE: Execute permission was denied on the object SP_SEND_DBMAILhttp://www.sqlservercentral.com/Forums/Topic1421304-2799-1.aspx[quote][b]eyespi20 (2/18/2013)[/b][hr]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![/quote]Does the user have a default profile associated ?Can you post output of below queries and verify if the environment is clustered or not ?[code="sql"]SELECT * FROM msdb.dbo.sysmail_sentitems order by sent_date descSELECT * FROM msdb.dbo.sysmail_allitems order by sent_date descSELECT * FROM msdb.dbo.sysmail_event_log order by log_date descSELECT * FROM msdb.dbo.sysmail_unsentitems select * from msdb.dbo.sysmail_configuration[/code]Fri, 22 Feb 2013 10:18:54 GMTSQLQuest29RE: Execute permission was denied on the object SP_SEND_DBMAILhttp://www.sqlservercentral.com/Forums/Topic1421304-2799-1.aspxYes, the role does have permission to execute the stored procedure sp_send_DBMAIL and the user is a member of the role. DBMail is enabled and a default profile is defined and test messages go through.Fri, 22 Feb 2013 05:32:54 GMTeyespi20RE: Execute permission was denied on the object SP_SEND_DBMAILhttp://www.sqlservercentral.com/Forums/Topic1421304-2799-1.aspxFirstly, 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. [u]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.[/u]"[quote][b]eyespi20 (2/18/2013)[/b][hr]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![/quote]Tue, 19 Feb 2013 02:17:15 GMTjvkondapalliExecute permission was denied on the object SP_SEND_DBMAILhttp://www.sqlservercentral.com/Forums/Topic1421304-2799-1.aspxWe 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!Mon, 18 Feb 2013 11:04:02 GMTeyespi20