Solved

sp_send_dbmail says access is denied

Posted on 2011-09-19
1
1,535 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
1 Comment
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
Comment Utility
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now