How can i delete the database mail sever account?

How can i delete the database mail sever account?

Hi Saif,

If you're looking for the SSRS mail settings you can simply delete them in the reporting services configuration utility:

Then click "Apply"

If you're referring to the "Database Mail" feature in SQL Server (not Reporting Services) then I would first ask if there are:

1. Anyone other than me using Database Mail
2. Any SQL Agent Alerts configured to use Database Mail
3. Any reason Database Mail should not be configured?

You can also just disable the Database Mail procs by using SP_Configure:

exec sp_configure 'Database Mail XPs', 0
reconfigure

Or as Milan points out you can also use the database mail procs to manage the profile.

Hi Saif,

I assume you have been trying to run the delete using SSMS. Have you tried just using the sp in T-SQL without the @force_delete parameter?

select * from msdb.dbo.sysmail_profile

to get the profile id and then:

msdb.dbo.sysmail_delete_profile_sp @profile_id = [profile_id]