Deleted SQL Server 2008 Database mail continues to send email notifications.

Question

On SQL Server 2008 standard I used the configuration wizard to create a Database Mail account.  It worked perfectly.  However, after deleting the account emails continue to be sent.  The "View, change, or delete an existing account" and the "View, change, or delete an existing profile..." are grayed out.  Where do I go to stop the emails.

Answer 1

Hi Charles,

Have you tried disabling the Database Mail option. Please try that and keep us posted!!

SP_CONFIGURE 'show advanced options', 1;
GO
RECONFIGURE;
GO
SP_CONFIGURE 'Database Mail XPs', 0;
GO
RECONFIGURE
GO

---

Thanks & Regards, Pramilarani.R

Answer 2

On SQL Server 2008 standard I used the configuration wizard to create a Database Mail account.  It worked perfectly.  However, after deleting the account emails continue to be sent.  The "View, change, or delete an existing account" and the "View, change, or delete an existing profile..." are grayed out.  Where do I go to stop the emails.

If those emails does seem to come from SQL server agent job or alert then you best way is to right click SQL server Agent and go to properties , open the alert system page and untick the "ENABLE MAIL PROFILE" option ( probably a Agent restart is required).

---

Thanks, Leks

Answer 3

Please upgrade to SQL 2012, Let us know if you still see the issue related to DatabaseMail. if your issue is not fixed in SQL 2012, please report this issue to Connect https://connect.microsoft.com/sqlServer/feedback

Thanks

Sethu  Srinivasan [MSFT]

SQL Server