July 14, 2010 at 5:37 am
Hi All,
Few months back, database mail is running fine but now when I tries to send a test mail or any job notification it status is 'unsent' in msdb.dbo.sysmail_allitems.
I am getting no error in database mail log. but in event viewer I am getting following error -
"Error Message:The update to the database failed. Reason: The EXECUTE permission was denied on the object 'sysmail_logmailevent_sp', database 'msdb', schema 'dbo'."
Though I am trying to send mail using administrator account and sql server agent is also running under administrator account.
I am using sql server 2008. Any suggestion.
Thanks
Vivek
August 20, 2011 at 5:42 am
I am also getting the same error. Pl help...
August 20, 2011 at 10:34 am
Are you logging into the server using a windows administrator account? When you state that SQL Server and SQL Server Agent are running with an administrator account - do you mean the service account is a member of the local administrators group?
If so, are you aware that by default on SQL Server 2008 installations - the builtin administrators groups is no longer added to SQL Server and granted sysadmin rights?
Are you also aware that running SQL Server with a privileged account is not recommended?
And finally, if you are also running on Windows Server 2008 - the security model has changed and unless you specifically un-checked the Service SID option in the install, the database engine and agent now get access to SQL Server using a Service SID instead of getting access directly.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
August 25, 2011 at 12:18 am
Hi Williams..
Thanks for helping.. I have solved my problem, just followed your suggestions...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply