
Detail Guideġ.Navigate to Object Explorer and open Management folder and choose Database Mail.Ģ.Right click on Database Mail, select Configure Database Mail.ģ.On the Configuration Task page, choose “Set up Database Mail by performing the following tasks”. Another handy option is to run system stored procedures to configure database email.

Besides, the easiest option to create database mail profile using SSMS GUI.

Configured email id will be used to send emails. In brief, database Mail configuration in SQL server includes the SMTP account setup. Available under Management > Database Mail. Configurations can be from SSMS GUI Object explorer. In addition to this, profile includes SMTP server account and configurations needed for sending emails. Database Mailĭatabase mail component provides functionality to create different profiles & accounts for sending emails. Giving more control to manage security and logging. Using this back end component rather than a frontend application for sending email is hassle-free. SQL Server uses the Database Mail component to configure and send emails. Emails used for sending an alert, message, query result, attachment or any other notification to users.

Sending email is a routine task needed in any application.
