Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Create Database Mail Profile and Account Dialog Box (Master Data Services Configuration Manager)

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.

Note Note

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.

Control Name

Description

Profile name

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.

Account name

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.

Control Name

Description

Email address

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 sales@contoso.com.

Display name

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 admin@contoso.com.

SMTP server

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.

Port number

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.

Control Name

Description

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.

Basic authentication

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.

User name

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.

Password

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.

Confirm password

Type the password again to confirm the password.

Anonymous authentication

Specify that the SMTP server does not require authentication. Database Mail will not use any credentials to authenticate on the SMTP server.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.