How to Configure E - Mail in SQL Server

In this article I am going to explain how to Configure E - Mail in SQL Server.
  • 2003


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 :


© 2020 DotNetHeaven. All rights reserved.