• Article

New Database Mail Account (Database Mail)

Use this page to create a new Database Mail account. A Database Mail account contains information for sending e-mail to an SMTP server.

About Database Mail Accounts

A Database Mail account contains the information that SQL Server uses to send e-mail messages to an SMTP server. Each account contains information for one e-mail server.

A Database Mail account is only used for Database Mail. A Database Mail account does not correspond to a SQL Server account or a Microsoft Windows account. When creating a Database Mail account, you must use the security model required by your SMTP server. Database Mail supports three methods of authentication:

  • Database Mail can connect to the SMTP server using the credentials as the SQL Server Database Engine service.

  • Database Mail can connect to the SMTP server using a user name and password provided solely for authentication with the e-mail server.

  • Database Mail can communicate with the SMTP server anonymously.

Security noteSecurity Note

If your SMTP e-mail server requires authentication, consider creating a user on that server specifically for Database Mail. This user should have minimal permissions, and should not be used for any other purpose.

Options

  • Account Name
    Type the name of the new account.

  • Description
    Type a description of the account. The description is optional.

  • E-mail address
    Type the name of the e-mail address for the account. This is the e-mail address that e-mail is sent from. For example, an account for SQL Server Agent may send e-mail from the address SqlAgent@Adventure-Works.com.

  • Display name
    Type the name to show on e-mail messages sent from this account. The display name is optional. This is the name displayed on messages sent from this account. For example, an account for SQL Server Agent may display the name SQL Server Agent Automated Mailer on e-mail messages.

  • Reply e-mail
    Type the e-mail address that will be used for replies to e-mail messages sent from this account. The reply e-mail is optional. For example, replies to an account for SQL Server Agent may go to the database administrator, danw@Adventure-Works.com.

  • Server name
    Type the name or IP address of the SMTP server the account uses to send e-mail. Typically this is in a format similar to smtp.<your_company>.com. For help with this, consult your mail administrator.

  • Port number
    Type the port number of the SMTP server for this account. Most SMTP servers use port 25.

  • This server requires a secure connection (SSL)
    Encrypts communication using Secure Sockets Layer. To use this option, you must have a certificate installed for SQL Server.

  • Windows Authentication using Database Engine service credentials
    Connection is made to the SMTP server using the credentials configured for the SQL Server Database Engine.

  • Basic Authentication
    Specify a user name and password required by the SMTP server, other than the credentials of the SQL Server Database Engine.

  • User name
    Type the user name that Database Mail uses to log in to the SMTP server. The user name is required if the SMTP server requires authentication.

  • Password
    Type the password that Database Mail uses to log in to the SMTP server. The password is required if the SMTP server requires authentication.

  • Confirm password
    Type the password again to confirm the password. The password is required if the SMTP server requires authentication.

  • Anonymous authentication
    Mail is sent to the SMTP server without login credentials. Use this option when the SMTP server does not require authentication.