Alternatives to MS Outlook MAPI client

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?
This will give you some options...
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Scott" <anonymous@.discussions.microsoft.com> wrote in message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...
> 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?
|||Thanks Tibor for the information. I've downloaded
everything and I've gotten the mailing feature to work.
But when I setup the DBMaint SMTP Alerter I see that it
appears to be working also (through Profiler) but it
never sends an email? Any suggestions?

>--Original Message--
>This will give you some options...
>http://www.karaszi.com/sqlserver/info_no_mapi.asp
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...[vbcol=seagreen]
MAPI[vbcol=seagreen]
feature.[vbcol=seagreen]
about[vbcol=seagreen]
and
>
>.
>
|||Do you see and calls to xp_smtp_sendmail in the profiler trace?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@.discussions.microsoft.com> wrote in message news:b97601c437a6$fd4876e0$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Tibor for the information. I've downloaded
> everything and I've gotten the mailing feature to work.
> But when I setup the DBMaint SMTP Alerter I see that it
> appears to be working also (through Profiler) but it
> never sends an email? Any suggestions?
> message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...
> MAPI
> feature.
> about
> and
|||Hi Tibor,
Is it possible to use Mozilla Thunderbird instead of
Outlook?

>--Original Message--
>This will give you some options...
>http://www.karaszi.com/sqlserver/info_no_mapi.asp
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...[vbcol=seagreen]
MAPI[vbcol=seagreen]
feature.[vbcol=seagreen]
about[vbcol=seagreen]
and
>
>.
>
|||I don't know... Is it MAPI compliant (extended for SQL Mail and Simple for Agent Mail)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Scott" <anonymous@.discussions.microsoft.com> wrote in message news:cb9d01c43933$782ff260$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi Tibor,
> Is it possible to use Mozilla Thunderbird instead of
> Outlook?
> message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...
> MAPI
> feature.
> about
> and
|||I can't find anything that says it is or isn't a MAPI
client. I also can't find anything that shows somebody
using it for SQL Mail and Agent Mail.

>--Original Message--
>I don't know... Is it MAPI compliant (extended for SQL
Mail and Simple for Agent Mail)?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message news:cb9d01c43933$782ff260$a401280a@.phx.gbl...[vbcol=seagreen]
on[vbcol=seagreen]
server[vbcol=seagreen]
there
>
>.
>
|||My guess is that it is not MAPI compliant. Just a guess, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@.discussions.microsoft.com> wrote in message news:d2b901c439c3$b0afe560$a601280a@.phx.gbl...[vbcol=seagreen]
> I can't find anything that says it is or isn't a MAPI
> client. I also can't find anything that shows somebody
> using it for SQL Mail and Agent Mail.
> Mail and Simple for Agent Mail)?

Alternatives to MS 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?You can use xp_smtp_sendmail from www.sqldev.net
It isn't nearly as integrated as SQL Mail, but by adding a few steps to your
SQL Agent jobs, you can get most of the same functionality. It is very
stable and does exactly what the documentation says it does.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> 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?|||"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> 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.
do you blame them ? installing Outlook on a database server is nuts ...|||http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> 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?|||"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uF33JP3NEHA.3124@.TK2MSFTNGP12.phx.gbl...
> http://www.aspfaq.com/2403
Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ; what
client do you recommend ? Thanks ...|||Should work in pretty much any, I don't have a personal preference...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Liz" <liz@.tiredofspam.com> wrote in message
news:eIpSqv3NEHA.3016@.tk2msftngp13.phx.gbl...
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:uF33JP3NEHA.3124@.TK2MSFTNGP12.phx.gbl...
> > http://www.aspfaq.com/2403
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>

Alternative to operator notification?

I have a new SQL server, Windows 2003, SQL 2000.
I had planned on NOT putting MAPI on this server, given that it's been
troublesome in the past.
On my other servers, I have MAPI installed, and when it gave problems, I
switched over to a stored procedure to send email. I plan to use this
same stored procedure to send mail with this new one.
However, in the notification tab on the new jobs, it won't recognize
anything but a MAPI profile on that box (the same as the old ones). On
the old ones, we have MAPI running to send an email if the job dies,
while it uses the stored procedure to send reports out.
Is there an alternative to using anything other than MAPI for the
Operator Notification tab? If so, what?
Thanks,
BCHi
Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
a notification you can use the GOTO STEP options on the advance tab to run a
specific step on failure or success, you can then call this procedure in tha
t
step.
John
"Blasting Cap" wrote:

> I have a new SQL server, Windows 2003, SQL 2000.
> I had planned on NOT putting MAPI on this server, given that it's been
> troublesome in the past.
> On my other servers, I have MAPI installed, and when it gave problems, I
> switched over to a stored procedure to send email. I plan to use this
> same stored procedure to send mail with this new one.
> However, in the notification tab on the new jobs, it won't recognize
> anything but a MAPI profile on that box (the same as the old ones). On
> the old ones, we have MAPI running to send an email if the job dies,
> while it uses the stored procedure to send reports out.
> Is there an alternative to using anything other than MAPI for the
> Operator Notification tab? If so, what?
> Thanks,
> BC
>|||In addition, another option with xp_smtp_sendmail and
operators is to use Db Maint SMTP Alerter. Check the
following:
http://www.dbmaint.com/SmtpAlerter.asp
-Sue
On Tue, 9 May 2006 10:14:02 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
>a notification you can use the GOTO STEP options on the advance tab to run
a
>specific step on failure or success, you can then call this procedure in th
at
>step.
>John
>"Blasting Cap" wrote:
>

Alternative to operator notification?

I have a new SQL server, Windows 2003, SQL 2000.
I had planned on NOT putting MAPI on this server, given that it's been
troublesome in the past.
On my other servers, I have MAPI installed, and when it gave problems, I
switched over to a stored procedure to send email. I plan to use this
same stored procedure to send mail with this new one.
However, in the notification tab on the new jobs, it won't recognize
anything but a MAPI profile on that box (the same as the old ones). On
the old ones, we have MAPI running to send an email if the job dies,
while it uses the stored procedure to send reports out.
Is there an alternative to using anything other than MAPI for the
Operator Notification tab? If so, what?
Thanks,
BCHi
Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
a notification you can use the GOTO STEP options on the advance tab to run a
specific step on failure or success, you can then call this procedure in that
step.
John
"Blasting Cap" wrote:
> I have a new SQL server, Windows 2003, SQL 2000.
> I had planned on NOT putting MAPI on this server, given that it's been
> troublesome in the past.
> On my other servers, I have MAPI installed, and when it gave problems, I
> switched over to a stored procedure to send email. I plan to use this
> same stored procedure to send mail with this new one.
> However, in the notification tab on the new jobs, it won't recognize
> anything but a MAPI profile on that box (the same as the old ones). On
> the old ones, we have MAPI running to send an email if the job dies,
> while it uses the stored procedure to send reports out.
> Is there an alternative to using anything other than MAPI for the
> Operator Notification tab? If so, what?
> Thanks,
> BC
>|||In addition, another option with xp_smtp_sendmail and
operators is to use Db Maint SMTP Alerter. Check the
following:
http://www.dbmaint.com/SmtpAlerter.asp
-Sue
On Tue, 9 May 2006 10:14:02 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
>a notification you can use the GOTO STEP options on the advance tab to run a
>specific step on failure or success, you can then call this procedure in that
>step.
>John
>"Blasting Cap" wrote:
>> I have a new SQL server, Windows 2003, SQL 2000.
>> I had planned on NOT putting MAPI on this server, given that it's been
>> troublesome in the past.
>> On my other servers, I have MAPI installed, and when it gave problems, I
>> switched over to a stored procedure to send email. I plan to use this
>> same stored procedure to send mail with this new one.
>> However, in the notification tab on the new jobs, it won't recognize
>> anything but a MAPI profile on that box (the same as the old ones). On
>> the old ones, we have MAPI running to send an email if the job dies,
>> while it uses the stored procedure to send reports out.
>> Is there an alternative to using anything other than MAPI for the
>> Operator Notification tab? If so, what?
>> Thanks,
>> BC
>>

Alternative to operator notification?

I have a new SQL server, Windows 2003, SQL 2000.
I had planned on NOT putting MAPI on this server, given that it's been
troublesome in the past.
On my other servers, I have MAPI installed, and when it gave problems, I
switched over to a stored procedure to send email. I plan to use this
same stored procedure to send mail with this new one.
However, in the notification tab on the new jobs, it won't recognize
anything but a MAPI profile on that box (the same as the old ones). On
the old ones, we have MAPI running to send an email if the job dies,
while it uses the stored procedure to send reports out.
Is there an alternative to using anything other than MAPI for the
Operator Notification tab? If so, what?
Thanks,
BCHi
Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
a notification you can use the GOTO STEP options on the advance tab to run a
specific step on failure or success, you can then call this procedure in tha
t
step.
John
"Blasting Cap" wrote:

> I have a new SQL server, Windows 2003, SQL 2000.
> I had planned on NOT putting MAPI on this server, given that it's been
> troublesome in the past.
> On my other servers, I have MAPI installed, and when it gave problems, I
> switched over to a stored procedure to send email. I plan to use this
> same stored procedure to send mail with this new one.
> However, in the notification tab on the new jobs, it won't recognize
> anything but a MAPI profile on that box (the same as the old ones). On
> the old ones, we have MAPI running to send an email if the job dies,
> while it uses the stored procedure to send reports out.
> Is there an alternative to using anything other than MAPI for the
> Operator Notification tab? If so, what?
> Thanks,
> BC
>|||In addition, another option with xp_smtp_sendmail and
operators is to use Db Maint SMTP Alerter. Check the
following:
http://www.dbmaint.com/SmtpAlerter.asp
-Sue
On Tue, 9 May 2006 10:14:02 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
[vbcol=seagreen]
>Hi
>Have you checked out http://www.sqldev.net/xp/xpsmtp.htm? Rather than using
>a notification you can use the GOTO STEP options on the advance tab to run
a
>specific step on failure or success, you can then call this procedure in th
at
>step.
>John
>"Blasting Cap" wrote:
>