blog

Home / DeveloperSection / Blogs / Create database mail profile in sql server step by step.

Create database mail profile in sql server step by step.

Anonymous User10683 07-Mar-2016

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.

    Updated 14-Mar-2018
    I am a content writter !

    Leave Comment

    Comments

    Liked By