Create Database Mail Profile and Account Dialog Box (Master Data Services Configuration Manager)
Applies To: SQL Server 2016 Preview
Use the Create Database Mail Profile and Account dialog box to create a Database Mail profile and a Database Mail account for the Master Data Services database. This profile will be used to notify users and groups by email when business rule validation fails.
A Database Mail profile is a collection of Database Mail accounts. A Database Mail account contains the information that SQL Server uses to send email messages to an SMTP server. When you create the profile and account in Master Data Services Configuration Manager, the account is automatically added to the profile and that account information is used to send emails.
You cannot use Master Data Services Configuration Manager to update existing Database Mail profiles or accounts, nor can you configure more than one account for a profile. To perform more advanced tasks with Database Mail, you can use SQL Server Management Studio or Transact-SQL scripts. For more information, see the Database Mail Configuration Objects section in SQL Server Books Online.
Type a name for the new Database Mail profile. This name must be unique among the Database Mail profiles configured for the Master Data Services database.
After you create this profile, it is available and selected on the Database page in Master Data Services Configuration Manager.
Type a name for the new Database Mail account to associate with this profile. This name must be unique among the Database Mail accounts configured for the Master Data Services database. This account does not correspond to a SQL Server account nor to a Windows user account.
Type the name of the email address for the account. This is the email address that email is sent from, and it must be in the format email_name@domain_name. An example email address is email@example.com.
Optional setting. Type the name to display on email messages sent from this account. An example display name is Contoso Sales Group.
Reply email address
Optional setting. Type the email address to use for replies to email messages sent from this account. An example reply email address is firstname.lastname@example.org.
Type the name or IP address of the SMTP server the account uses to send email. An example SMTP server format is smtp.<company_name>.com. For help with this, consult your mail administrator.
Type the port number of the SMTP server for this account. The default SMTP port is 25.
This server requires a secure connection (SSL)
Encrypts communication using Secure Sockets Layer (SSL).
Database Mail can be sent by using the credentials of the SQL Server Database Engine, by using other credentials that you supply, or anonymously. As a best practice, if your email server requires authentication, create a specific user account to use for Database Mail. This user account should have minimal permissions, and should not be used for any other purpose.
Windows Authentication using Database Engine service credentials
Specify that Database Mail should use the credentials of the SQL Server SQL Server Database Engine Windows service account for authentication on the SMTP server.
Specify that Database Mail should use a specific user name and password to authenticate on the SMTP server. This information is used only for authentication with the email server, and the account need not correspond to a SQL Server user or user on the computer running SQL Server.
Type the name of the user account that Database Mail uses to log on to the SMTP server. A user name is required if the SMTP server requires basic authentication.
Type the password that Database Mail uses to log on to the SMTP server. A password is required if the SMTP server requires basic authentication.
Type the password again to confirm the password.
Specify that the SMTP server does not require authentication. Database Mail will not use any credentials to authenticate on the SMTP server.