Follow

Can not create a case: "The EXECUTE permission was denied on the object 'sp_send_dbmail',..."

Created by: Brandon Harmon
Created date:
Last Updated date:

Problem

After finishing the case creation wizard, the case is not in the case list and was not created.


 %PUBLIC%\Documents\AccessData\ResolutionOneLogs\AdgBusinessServices.txt log contains the following error corresponding with the case creation:

The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

 

Resolution

Open up MSSQL and check for any triggers in:

 

And also in:

 

Find the trigger that is trying to use "sp_send_dbmail" and disable or delete it.

 

Cause

Whenever this error has been seen, it was because someone created a trigger in MSSQL calling the stored procedure "sp_send_dbmail," usually in an attempt to have an email notification sent when a database is created. The service account does not have permissions to use sp_send_dbmail, which causes case creation to fail.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk