Sunday, February 12, 2012

Alternatives to Outlook for SQLMail?

I want to be able to use SQLMail to send me alerts on
task failures, etc. Microsoft says we have to use a MAPI
client like MS Outlook to take advantage of this feature.
However, when I talk with my system administrators about
placing Outlook or similar mail clients on the server
they get all upset and scream about security. Are there
alternatives to Outlook that are more secure or less
intrusive or anything that would make the sa's happy and
still be able to use SQLMail?If you want to just use SQL Mail then it needs to be a mapi
client. However, you don't have to use SQL Mail for emails
on task failures and other email functionality. You can use
smtp and an extended stored procedure that will send mail
via smtp, no mapi. You can download this xp and get more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
I've gone that route at several client sites without any
problems.
-Sue
On Tue, 11 May 2004 08:44:28 -0700, "Scott"
<anonymous@.discussions.microsoft.com> wrote:

>I want to be able to use SQLMail to send me alerts on
>task failures, etc. Microsoft says we have to use a MAPI
>client like MS Outlook to take advantage of this feature.
>However, when I talk with my system administrators about
>placing Outlook or similar mail clients on the server
>they get all upset and scream about security. Are there
>alternatives to Outlook that are more secure or less
>intrusive or anything that would make the sa's happy and
>still be able to use SQLMail?|||Agree with Sue. XPSMTP is a viable alternative.

No comments:

Post a Comment