Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kris
Starting Member
3 Posts |
 Posted - 2003-08-04 : 16:06:01
|
| We have SQL 2000 on Win 2000. I like to use SQLMail from sql server using Outlook profile for emailing purpose. SMTP mail with stored procedure is my last option. The problem is that our network manger denies to install OutLook client on SQL server box. He has concerns about security of SQL server with the installation of OutLook client on the box. Please let me know if there are real security issues with outlook client on SQL 2000 box. If it is a real security concern then I may go for SMTP mailing, which mean a lot work for reconfiguring all my jobs. I have approx 60 jobs with an average 3 steps. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-04 : 16:15:16
|
| What security concerns does he have about Outlook? We've got Outlook installed on all of our production servers.Tara |
 |
|
|
Kris
Starting Member
3 Posts |
Posted - 2003-08-04 : 16:54:50
|
| I didn't get a clear answer, one of those managerial decisions.That is why I am posting here to find out any security concerns. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-04 : 17:05:07
|
| I would think that as long as you have the latest security patches and service packs installed, that you should be fine. We install the security patches within 48 hours of MS announcing it.Tara |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-04 : 19:08:29
|
| The biggest problem security-wise with Outlook are email viruses and worms. If you can lock Outlook down so that there's no chance of these coming through, then you're pretty safe. Unfortunately Outlook's past reputation has forever tarnished it for most system admins and they will never install it near something important like SQL Server. I can certainly relate to your network manager, I'd still be hesitant to put Outlook on the same box as SQL Server. |
|
|
|
Kris
Starting Member
3 Posts |
Posted - 2003-08-05 : 14:50:41
|
| --------------------------------The biggest problem security-wise with Outlook are email viruses and worms. -------------------------------Thanks for your feed back. we will never open the outlook client on SQL server box. We install the outlook client on the SQL box so that SQL server can use outlook DLLs to send mails. (just to send mails, not for receiving). How can virus or Worms affect the system if we even don't open the mail GUI on the server. I had this outlook client on my old server for 4 years and no problems at all. Basically what I am asking is that given the above scenario, what are the technical security problems of installing the outlook client. I like to here some techincal details. |
|
|
|
|
|
|
sqlmail outlook security