TN Hist 254 Setting up a SQL Database Mail Account

Description

This article from InSource shows how to setup and test a SQL Database mail account.

• Author: Joseph Hefner
• Published: 05/25/2016
• Applies to: SQL Server 2005 and later

Details

1. Open SQL Server Management Studio and navigate to Management \ Database Mail.
2. Right Click on Database Mail and choose “Configure Database Mail”
   
   Click the "Next" button at the following screen:
   
3. Type in a profile name for this account and click the "Add" button:
   
4. Enter the email server and account information and click the "Next" button. This is the account that emails will be getting sent from by the SQL Mail system. In this example, I have used a yahoo email account.
   
5. Click the"Finish" button and then "Close" to complete the creation of the mail profile:
   
   
6. To test the new account, right click on "Database Mail" and choose "Send Test E-mail":
   
7. Choose the email profile you just created and enter in an address that you wish to send the test email to and click the "Send Test E-Mail" button and then "OK":
   
   

If everything is setup correctly, you should receive a test message from the SQL Database Mail.