Manage Existing Account (Database Mail)

Use this page to manage an existing Database Mail account.

Options

  • Account name
    Select the account to view, update or delete.
  • Delete
    Delete the selected account. You must remove this account from associated profiles, or delete such profiles, before you delete the selected account.
  • Description
    View or update the description of the account. The description is optional.
  • E-mail address
    View or update 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 Microsoft SQL Server Agent may send e-mail from the address SqlAgent@Adventure-Works.com.
  • Display name
    View or update 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
    View or update 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
    View or update the name 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
    View or update 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.
  • Windows Authentication using Database Engine service credentials
    Connection is made to the SMTP server using the credentials configured for the SQL Server Database Engine service.
  • Basic Authentication
    Specify the user name and password required by the SMTP server.
  • User name
    View or update the user name that Database Mail uses to log in to the SMTP server. The user name is required if the SMTP server requires basic authentication.
  • Password
    Change the password that Database Mail uses to log in to the SMTP server. The password is required if the SMTP server requires basic authentication.
  • Confirm password
    Type the password again to confirm the password. The password is required if the SMTP server requires basic authentication.
  • Anonymous authentication
    Mail is sent to the SMTP server without login credentials. Use this option when the SMTP server does not require authentication.

See Also

Other Resources

Database Mail Accounts
sysmail_update_account_sp (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance