Configure Database Mail when SQL Server needs to send administrative notifications. Job failures, maintenance status and operator alerts are useful examples. SQL Server should not replace a dedicated bulk-mailing application.
In this SQL in Sixty Seconds video, I demonstrate the Database Mail configuration wizard. If you prefer written instructions and images, see Configure Database Mail: Send Email From SQL Database.
Before Configuring Database Mail
Database Mail sends through an SMTP server using an account and a mail profile. Use the SMTP settings and authentication method approved by your mail administrator. The 2013 video shows the wizard of its time; its example settings are not universal provider settings.
An authorized sysadmin configures accounts and profiles. A non-sysadmin sender needs membership in DatabaseMailUserRole in msdb and access to the chosen profile. Restrict access to the users who need it. SQL Server Agent notification settings must also be configured for job alerts.
Watch the Original Video
Related Tips
What would you like to see in the next SQL in Sixty Seconds video?
Database Mail is not a bulk-mailing system, it is a useful channel for operational notifications.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
3 Comments. Leave new
Nice article, Thanks :)
Agreed. If an application need to send mail then it should use mediums other than SLQ server.
This approach is true that SQL Server is a Platform vision that helps your organization to manage any data, any place, and any time.