You are here: Re: SQL mail work around « MsSQL Server « IT news, forums, messages
Re: SQL mail work around

Posted by jlaustill@gmail.com on 02/27/07 19:11

On Feb 27, 10:27 am, "AlterEgo" <altereg...@dslextreme.com> wrote:
> Joshua,
>
> It sounds to me like the network Nazis just don't want to take the time to
> add another security layer which should be in place anyway. I agree
> wholeheartedly with Strider. Work with your boss to build a case.
>
> 1. Your security layer should already be blocking incoming and outgoing port
> 25 for all servers and workstations except your mail server. If not, there
> is already a significant security issue. If you have local admin rights to
> your workstation, set up a local SMTP server and send a few emails through
> the firewall. If they make it through, then you've exposed a security hole
> far greater than just email on servers.
>
> 2. Determine what the ongoing costs (your time) are to continue doing things
> this way. Compare it to the one-time cost (network admin to configure the
> firewall) to protect the servers. Come up with a break-even analysis, which
> may be be a couple of months. Show how much money it will cost over the next
> two years if the status quo is maintained.
>
> Good luck,
>
> -- Bill
>
> <jlaust...@gmail.com> wrote in message
>
> news:1172590841.554380.93290@a75g2000cwd.googlegroups.com...
>
> > Hey yall,
>
> > I have a problem, I'm a DBA for about 250 databases. I currently have
> > ZERO means of notification on them. I put together an entire plan for
> > using SQL mail, got a pop3 account set up and all that jazz, but when
> > I put the request into my company to get outlook installed on my sql
> > servers they shut me down. The security guys said no email on servers
> > period even if it's outgoing only because someone might hack it. As
> > far as I know that's really the only way to shoot information about my
> > maintenance plans and other notifications I need.
>
> > So with out being allowed to use mail, can anyone suggest any means of
> > getting this information? I looked for a central control panel or
> > dashboard for sql server and couldn't find anything. It would be
> > really nice to have a program that could connect to all my sql servers
> > and just pop up an alert if something goes wrong. What I'm down to
> > now is just connecting to all these servers through enterprise manager
> > and clicking down to the jobs and checking last run status' and
> > checking stuff out that way, which is REALLY time consuming.
>
> > Any suggestions would be so greatly appreciated here!!!
>
> > Joshua

After reading your responses I realize that you are right. Downtime
in my business is in the millions per hour potentially. I will have
to put together the analysis of time vs cost, that would certainly be
helpful. I work for a bank, so money numbers work well. Certainly
not the answers I was expecting/hoping for, but extremely helpful non
the less, thanks guys!!!

Joshua

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация