Setting Up SQL/Database Mail on SQL Server

Complete the following steps to set up Database Mail on Microsoft SQL Server Standard Edition:

  1. Go to Start>Programs>Microsoft SQL Server 2014>SQL Server Management Studio. (Or open the specific Microsoft SQL Server folder for the SQL Server you are using, such as 2008 R2, 2012, or 2014)
  2. Open the Object Explorer, then the Management node.
  3. Right click on the Database Mail, then select Configure Database Mail.
  4. The Database Mail Configuration Wizard displays.
    • Click on Next, and select "Set up Database Mail by performing the following tasks" option on the Select Configuration Task panel.
    • Click Next to continue. However, if the Database Mail feature is not available, click Yes to enable it.
    • The New Profile form displays. Enter the Profile Name of your choice and description. Click the Add button on the right-side of the panel.
    • The New Database Mail Account panel displays. Verify the existing SMTP account information or enter the new accounting information. Click the OK button to add the database mail account to the mail profile.
    • Click Next to display the Manage Profile Security panel. Select the Public check box to make the profile a public profile; making this accessible to all users of any mail-host database.
    • Click Next to display the Configure System Parameters panel. It is recommended to use the default configuration parameters. However, if you have intermittent problems, you might want to alter the settings for the Account Retry Attempts and Account Retry Delay. This is most helpful if you have an unreliable connection or heavily loaded mail server.
    • Click Next to display the Complete the Wizard panel. Verify the actions the wizard is about to perform.
    • Click Finish to execute these actions on the server and the Configuration widow displays. Once complete, click Close.
  5. Next test the SQL Server Database Mail.
    • Open SQL Server Management Studio, right-click on the Database Mail node and select Send Test Email.
    • The Send Test Email form displays. Select the Database Mail Profile and enter the To email address, Subject, and Body. Click the Send Test Email button.
      • If Database mail has been enabled, a window displays confirming that the email was sent successfully.
      • If Database mail was not enabled for the SQL Server, this message displays "An exception occurred while executing a Transact-SQL statement or batch." For more information, see article 4381 in the Knowledgebase.
    • If successful, a Database Mail Test - Message window displays. You should also check the recipient's mailbox used to verify receipt of the test email.

Note: This information has been supplied as a courtesy to our MIP Fund Accounting customers. If you have questions about setting up, maintaining, or troubleshooting your SQL Mail, we strongly recommend that you consult your Authorized Business Partner. If you do not have a relationship with an Authorized Business Partner then contact the Professional Services group.