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?
Check the free SMTP mail for SQL Server at
http://www.sqldev.net/xp/xpsmtp.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b65e01c4376e$f28b9260$a501280a@.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?
Showing posts with label failures. Show all posts
Showing posts with label failures. Show all posts
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.
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.
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)?
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...
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>
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...
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>
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...
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>
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...
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>
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 ...
>
>
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 ...
>
>
Subscribe to:
Posts (Atom)