Microsoft SQL Server/Configuring Mail

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[1].
  • 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

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.

References

  1. ? http://technet.microsoft.com/en-us/library/ms191207%28v=sql.105%29.aspx

  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.


Microsoft_SQL_Server/Configuring_Mail
 

Manage research, learning and skills at IT1me. Create an account using LinkedIn to manage and organize your IT knowledge. IT1me works like a shopping cart for information -- helping you to save, discuss and share.


  Contact Us  |  About IT1me.com |  IT Training & References |  IT Careers |  IT Hardware |  IT Software |  IT Books