In this article I would discuss about the Database Mail which is used to send the Email using SQL Server.

 Database Mail Configuration

To Create a Database Mail profile
  • In Object Explorer, connect to the SQL Server instance you want to
         configure Database Mail on, and expand the server tree.
  • Expand the Management node
  • Double click or (right click configure database mail ) Database Mail to open the Database Mail Configuration Wizard.
    Create database mail profile  in sql server step by step.

  • On the Select Configuration Task page, select Manage Database Mail

    accounts and profiles option and click Next.

    Create database mail profile  in sql server step by step.

  • On the Manage Profiles and Accounts page, select Create a new

profile option, and click Next.


Create database mail profile  in sql server step by step.

  • On the New Profile page, specifiy the Profile name, Description and

      add accounts to be included in the profile, and click Add button .


  • create new email Account.
Create database mail profile  in sql server step by step.

  •  Click On New Account 
Create database mail profile  in sql server step by step.


  • On the New DataBase Mail Account page, specifiy the Account name,

Description and add accounts to be included in the SMTP Details, and


click OKbutton . 


Create database mail profile  in sql server step by step.

Click to next Button

Create database mail profile  in sql server step by step.

Click to next Button
Create database mail profile  in sql server step by step.
Click to next Button
Create database mail profile  in sql server step by step.

Click To Finish Button
Create database mail profile  in sql server step by step.

Click To Close Button
Create database mail profile  in sql server step by step.

Right Click to Database mail and send test E-mail.

Create database mail profile  in sql server step by step.

Select your mail profile and include to email Id ,subject,body and  Send Test E-Mail.

Create database mail profile  in sql server step by step.

I hope this article help full for you.
  Modified On Mar-14-2018 01:55:51 AM

Leave Comment