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

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.