1
vote
0answers
179 views

Troubleshooting Database Mail issues and Service Account permissions in SQL Server

I am having difficulties troubleshooting a Database Mail issue. When I try to stop and start the service using sysmail_start_sp and sysmail_stop_sp, I see a critical error in the Administrative Logs ...
2
votes
1answer
141 views

SQL Server Alert - Description (None) [closed]

For every system Alert defined to send an email, we receive a 2 alerts with the following bodies. How do I stop the message with the empty (None) description? Empty Alert SQL Server Alert System: ...
4
votes
1answer
218 views

Denied access sending dbmail while impersonated under a login with sysadmin privilege

This question is similar to but not the same as this. I created a stored procedure and set it to execute under the context of a sysadmin login (let's called it sys1). For testing purposes, I only ...
7
votes
1answer
1k views

Trouble With Database Permissions for sp_send_mail

I am trying to send database mail but I am getting EXECUTE permission denied on the object 'sp_send_dbmail' database 'msdb', schema 'dbo'.. I code I am running is as follows: SELECT SUSER_NAME(), ...