Improve company productivity with a Business Account.Sign Up

x
?
Solved

sp_send_dbmail says access is denied

Posted on 2011-09-19
1
Medium Priority
?
1,689 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 2000 total points
ID: 36561852
0

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
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.
Viewers will learn how the fundamental information of how to create a table.

606 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