June 17, 2014 at 4:15 am
Would someone kindly clear up my confusion around these mailing systems please.
Am i right in thinking that dbmail can stay disabled and SendMail will still work.
how does sendmail work/what does it use to send the mail if it doesn't rely on dbmail and sp_send_dbmail?
Crucially, what are the security implications of using sendmail? are there any? who can use it?
thanks in advance
June 17, 2014 at 4:20 am
The Send Mail Task in SSIS uses an SMTP connection manager, meaning it connects to the mail server specified in that connection manager.
Database mail is managed inside SQL Server, but it also connects to an SMTP server.
So if you use different SMTP servers, you can disable database mail but still use the Send Mail Task in SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 17, 2014 at 4:48 am
Ok thanks for the quick reply.
What are the security concerns around either ?
June 17, 2014 at 5:15 am
Steven Jones-245254 (6/17/2014)
Ok thanks for the quick reply.What are the security concerns around either ?
It is like any other email system.
People who have access can send emails. (unless you block it with a firewall)
In SSIS, most likely only developers actually design SSIS packages, right?
If you use Exchange as an SMTP server, it can work with Windows Authentication.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply