Re: Application sending email
- From: "A McGuire" <allen.mcguire@xxxxxxxxxxxxxxxxx>
- Date: Tue, 18 Jul 2006 15:35:58 -0500
Understanding that Outlook has security issues, I personally have used SQL
Mail in the past with the Outlook client and had great success. Although it
may be one of the top reasons for 'downtime' (if you call a reboot
downtime), how much downtime is that? If you have 99.9% uptime and SQL Mail
is responsible for .1% downtime, is that acceptible? It was for me.
If you stay on top of your Outlook updates, restrict access to the xp_'s
(xp_sendmail, for example), and do your homework on SQL Mail, there is some
reward to offset the risk. There are factors that may sway you one way or
another depending on your situation.
My server sent an average of around 100 emails per minute - with SQL Mail
and the Outlook client.
"Cindy" <Cindy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:943EC1D1-1E2A-413A-8DF5-A5F919125DD9@xxxxxxxxxxxxxxxx
Hi:
I would like to know security implications on two different ways to enable
an application to email alerts.
1. Installing outlook client for application to call.
2. Using CDOSYS to point to SMTP server and send email using AD
username/password.
Thanks for any input.
.
- Prev by Date: Disable Sysadmin to view metadata in SQL2005
- Next by Date: Re: Change UDF Owner
- Previous by thread: Disable Sysadmin to view metadata in SQL2005
- Next by thread: Re: Securing the MDF file
- Index(es):