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

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 :

Clipboard03.jpg

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

Clipboard05.jpg

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

Clipboard07.jpg

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

Clipboard09.jpg

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

Clipboard11.jpg

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

Clipboard13.jpg

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 " :

Clipboard16.jpg

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

Clipboard18.jpg

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

Clipboard20.jpg

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 :

Clipboard22.jpg

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

Clipboard24.jpg


© 2020 DotNetHeaven. All rights reserved.