SQL 2000 Cluster (Active, Passive) E-mail   

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.

date: Fri, 20 Jun 2008 09:37:01 -0700   author:   charles18602

Re: SQL 2000 Cluster (Active, Passive) E-mail   

>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.

You can use SQLMail in a clustered instance but you have to create the same 
MAPI profile (Outlook) on both nodes.
It's not a good idea to install Outlook on a production server (clustered or 
not clustered), so I prefer to use this solution

http://www.sqldev.net/xp/xpsmtp.htm

that do not require to install anything.

Ciao

-- 
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

date: Fri, 20 Jun 2008 20:41:31 +0200   author:   Luca Bianchi

RE: SQL 2000 Cluster (Active, Passive) E-mail   

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:

> 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.

date: Fri, 4 Jul 2008 12:11:01 -0700   author:   Ross Mistry