SQL 2000 Cluster (Active, Passive) E-mail

#1

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.

#2

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.

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

#3

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.

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

#4

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.

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

#5

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.

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

#6

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.

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

#7

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.

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

#8

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.

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

#9

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.

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

#10

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.

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