How to configure SQL Server Database Mail in 2014

SQL Server database mail keeps ail copies of the sent or outgoing email messages and user can see them in the MSDB database views section like sysmail_allitems, sysmail_unsentitems, sysmail_faileditems and sysmail_sentitems etc. User can view the sysmail_event_log for log details and to check the email message status run the query against this view in query editor. In SQL Server database mail, it is possible to add multiple user profiles at the same time and their requirement will be according to the need.
Follow Simple Manual Steps to Configure Database Mail

1) Open SSMS and go to the Management node on left panel.

2) Expand the Management node then go to the Database Mail option, Right click on the Database Mail, and then select Configure Database Mail.

3) After that a new pop-up Windows will be opened then click on the next button.

4) New Windows will show options where user have to choose 1^st one i.e. Setup database mail then click on next button.

5) On the next Window fill up the profile filed as your name, description field is not mandatory then click on Add button.

6) New Window will be shown as below, fill up all the fields as below:

Here I have used my managed account which is same as new, so fill up Outgoing SMTP fields

• Email address- your email address
• Display Name- your display name
• Reply email – same as above email address
• Server name – smtp.gmail.com (here I have used gmail smtp address) and Port no- 587

Select Authentication- Basic Authentication, type username, email passwords etc.
After all fields completion, click on the next button.

7) New Window will show profile name and on its next row select yes to default profile. Then click on next.

8) Next Window will show system parameter, view them and click on Next button.

9) New Window will show status of the created profile. Then click on the finish button.

10)  At last window will show success status of the account then click close.



11) To check the mail database, right click on the database mail then go to Send Test E-Mail

12) Then type email address on To field then message, then click on send email button.