Solved

sp_send_dbmail says access is denied

Posted on 2011-09-19
1
1,614 Views
Last Modified: 2012-05-12

I received and error message below:

Duration            00:00:00
Sql Severity            14
Sql Message ID            229
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Message
Executed as user: domain1\userA. The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229).  The step failed.



But User domian1\userA has following privilled in msdb database, I even add him as db_owner but the same error message seems to be exist again and again
sp_send_dbmail            ALTER
sp_send_dbmail            CONTROL
sp_send_dbmail            DELETE
sp_send_dbmail            EXECUTE
sp_send_dbmail            INSERT
sp_send_dbmail            RECEIVE
sp_send_dbmail            REFERENCES
sp_send_dbmail            SELECT
sp_send_dbmail            TAKE OWNERSHIP
sp_send_dbmail            UPDATE
sp_send_dbmail            VIEW CHANGE TRACKING
sp_send_dbmail            VIEW DEFINITION
0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 36561852
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question