How To Configure E - Mail In SQL Server

Introduction

In this article I am going to explain how to Configure E - Mail. You can send E-Mail from SQL server. Before sending e mail we have to configure e mail in SQL server.  Here I am explaining how to configure it.

Steps to configure E - Mail in SQL server 

Step 1 : Start SQL server :

Step 2 : Expend Management and select Database Mail => Then select Configure database mail :

Step 3 :  Database configuration wizard appear, click on Next button :

Step 4 : There are four option, select first option " Set up Database Mail by performing the fallowing task" and click on Next button :

Step 5 : Now you have to put Profile name and Description and click on Add button to fill other detail :

Step 6 : A new window appear click on New Account :

Step 7 : Now You have to put other detail like account name, description, email address, server name, port number, user name and password  and click on "OK " :

Step 8 : Now you will see that vipendra account is added and click on next :

Step 9 : It show some information about your mail account and click on Next Button :

Step 10 : This window show information about your account name, mail server and profile name. If every thing ok then click on finish button to complete process :

Step 11 : It show a new window which display information that mail is successful configured :