|
|
Posted by Greg D. Moore \(Strider\) on 02/27/07 16:07
<jlaustill@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.
No, what they're saying is, "we're so incompetent, we can't secure against
this."
Sorry, but I'd be FAR more concerned about SQL injection attacks.
It's very easy to firewall off the SQL Servers, make sure they can't accept
SMTP/POP3 connections and can only SEND email.
It's pretty easy to do.
But, I wouldn't fight them. I'd go a different route. How much is downtime
worth your company?
If backups fail and then a server crashes and you're not notified, what
happens then?
Go to the person who controls the pursestrings.
> As
> far as I know that's really the only way to shoot information about my
> maintenance plans and other notifications I need.
>
Pretty much
> 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.
You can try using NET SEND, but I don't find that very useful.
You can bypass them and use something like BLAT, a command line mail program
to send stuff.
> 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.
You can also forward event log events to a centralized server and monitor
that.
I've used ServersAlive for a number of things and it can be scripted to do a
bunch of stuff.
Might be able to do something like a select against the jobshistory table to
get a status and make a web page out of that.
But, I find using SQLMail so jobs can send email immediately very powerful.
I'd continue to work on that.
>
> Any suggestions would be so greatly appreciated here!!!
>
> Joshua
>
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Navigation:
[Reply to this message]
|