Thursday, August 8, 2019

SQL SERVER: Configure Database Mail using wizard


Here in this article I am going to explain how to configure database mail using wizard in sql server.

As you know we can send email from Sql server. To send email from Sql server firstly we need to configure the database mail in Sql server. Kindly follow the below given steps to configure database mail in Sql server.

STEP 1: Connect to Database engine. In object explore expand the Management option. Right click on Database Mail and select configure database mail.

SQL SERVER: Configure Database Mail using wizard

STEP 2: Database mail configuration wizard will be open. Click on NEXT button.

SQL SERVER: Configure Database Mail using wizard

STEP 3: From select configure task screen, select the first option i.e. set up database mail by performing the following task and click on NEXT button.

SQL SERVER: Configure Database Mail using wizard

STEP 4: New profile screen will be open. Enter the profile name and description. Click on ADD button.

SQL SERVER: Configure Database Mail using wizard

STEP 5: New database mail account screen will be displayed. Enter the information as required to send email like email address, display name, server name, port, secure connection, username and password. In this example I am going to configure the Gmail account for emailing. After enter all information click on NEXT button.

SQL SERVER: Configure Database Mail using wizard

 This will be closed and profile screen will be displayed with account name and email address. Click on NEXT button.

SQL SERVER: Configure Database Mail using wizard

STEP 6: Manage profile security screen, check the public checkbox and if you want to set this email profile default, select yes otherwise leave it and click on NEXT button.

SQL SERVER: Configure Database Mail using wizard

STEP 7: Configure system parameters screen, no need to change anything on this screen. Keep it with default parameters value and click on NEXT button.

SQL SERVER: Configure Database Mail using wizard

STEP 8: Complete wizard screen, Click on FINISH button.

SQL SERVER: Configure Database Mail using wizard

STEP 9: This is Last screen on configuration wizard. In this screen you will get success message of configuration. Click on CLOSE button. If any error occurred or warning you will see that one here.

SQL SERVER: Configure Database Mail using wizard


Database mail configuration is complete. You can check it by sending test email.



No comments:

Post a Comment