Database Mail is a way to sending e-mail messages from the SQL Server Database Engine. Using this we can send a mail to the user. Message may have report summary or any other information.
Let’s start to configure the database mail in sql server.
Open sql server connect to database engine.
Go to Management
In Management you will see Database Mail. Right click on this.
You will get database mail configuration wizard
Click next
If you are configuring first time select first radio button.
Click next
Create new profile and write the profile name and description.
Click on Add. You will get a new window new database mail account.
Create a new account.
Set up account name and details.
If you are using organization server then you gave the details of organization mail server and port number. If you are using gmail then
Server name is smtp.gmail.com
Port number is 587
And select SSL secure connection.
For SMTP Authentication better to use basic authentication.
Provide the user name and password.
Click ok.
Now new SMTP account will be added.
Click next
Manage your profile. If there are multiple account the set one as default profile.
Click next.
In system parameter you can set the above properties like Account retry attempts , Max file size, Prohibited attachment etc.
Click next.
Now configuration has been completed.
You will Configuration report.
Now time to test and send the mail using database mail
Right click on database mail.
Click on Send Test E-Mail
Write to whom you want to send the mail.
Click on Send Test E-Mail
Open the gmail.
Mail body
Hope this article helps you. Thanks!!!
