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?
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
MCTS : 2005, 2008Active SQL Server Community Contributor