The SQL Mail problems, that we faced in SQL Server 7.0 and 2000, are no more.
SQL Server 2005 supports and uses SMTP email now and there is no longer a
need to MAPI client to send email. In SQL Server 2005, the mail feature is
called Database Mail.
The high level steps are:
Database Mail has four components.
1. Configuration Component
Configuration component has two sub components. One is the Database Mail
account, which contains information such as the SMTP server login, Email
account, Login and password for SMTP mail.
The Second sub component is Database Mail Profile. Mail profile can be
Public, meaning members of DatabaseMailUserRole in MSDB database can send
email. For private profile, a set of users should be defined.
2. Messaging Component
Messaging component is basically all of the objects related to sending email
stored in the MSDB database.
3. Database Mail Executable
Database Mail uses the DatabaseMail90.exe executable to send email.
4. Logging and Auditing component
Database Mail stores the log information on MSDB database and it can be
queried using sysmail_event_log.
--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration
Look forward to my new book called SQL Server 2008 Management & Administration
"charles18602" wrote:
Quote:
I need to setup SQL to automatically email out of report each night when it
is done, i've done it in the past on a stand alone server by just installing
outlook setting up a profile and setting the sql services to use that
account. Not sure how to do it in a cluster or even if outlook could be
installed on the sql cluster servers. Can it somehow use a smtp relay? If
it can could someone give me instructions on how to do it.
|
RE: SQL 2000 Cluster (Active, Passive) E-mail -
07-04-2008
, 02:11 PM
Linear Mode
