Microsoft SQL Server/Configuring Mail

From Wikibooks, open books for an open world
< Microsoft SQL Server
Jump to: navigation, search

First of all: SQL Server Mail does not depend on Extended Mapi

Prerequesites for Database Mail:

  • Database Mail has to be enabled via the Surface Area Configuration Tool, Database Mail Configuration Wizard or the sp_configure.
  • Service Broker needs to be enabled in the Database mail host database msdb
  • The Database Mail externals executables need access to the SMTP Server

Architecture[edit]

Four Components: Configuration Component, Messaging Component, Database Mail executable, Logging and auditing component.

The configuration components consists of a database Mail account and a Database Mail profile. The Database Mail account contains the information that SQL Server uses to send e-mail messages to the SMTP server, such as the SMTP server name, the authentication type, and the e-mail address.