473,320 Members | 1,845 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL mail work around

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

Feb 27 '07 #1
3 1461
<jl*******@gmail.comwrote in message
news:11*********************@a75g2000cwd.googlegro ups.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
Feb 27 '07 #2
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

<jl*******@gmail.comwrote in message
news:11*********************@a75g2000cwd.googlegro ups.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

Feb 27 '07 #3
On Feb 27, 10:27 am, "AlterEgo" <altereg...@dslextreme.comwrote:
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.comwrote in message

news:11*********************@a75g2000cwd.googlegro ups.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

Feb 27 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Alistair | last post by:
can anyone see why this wouldn't work...it's driving me nuts Set objcdmail = Server.CreateObject("CDONTS.NewMail") objcdmail.From = "me@mydomain.com" objcdmail.To = "me@mydomain.com"...
8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
4
by: Brett Porter | last post by:
Hi, My ASP.Net applications frequently make use of the System.Web.Mail namespace to send emails. I have set SmtpMail.SmtpServer = "localhost" and the emails send out fine UNTIL an email is sent...
11
by: Dennis | last post by:
I am using the following code that I got from this newsgroup to start a user's default e-mail editor and it works ok. However, I would like to attach a file to the editor (like using word as...
34
by: antonyliu2002 | last post by:
I've set up the virtual smtp server on my IIS 5.1 like so: 1. Assign IP address to "All Unassigned", and listen to port 25. 2. Access Connection granted to "127.0.0.1". 3. Relay only allow...
0
by: howardr101 | last post by:
Hi, Have hunted around on the groups and can't find anything, hence. I've tried this against 2 mail servers (mailtraq and hmailserver) and it occus with both. The problems seems to be that...
13
Nert
by: Nert | last post by:
hello every one, i need help.. how can i use the mail() funtion in php? when ever i execute the mail function i continuesly receive this error message: what do i need to do in order for me...
12
by: e_matthes | last post by:
Hello everyone, I am trying to use the mail() function to send a simple, text-only message. I have two websites hosted by the same company, on different servers. One is old and established,...
1
by: Alan | last post by:
Hi Expert, Dim u As MembershipUser = Membership.CreateUser("jfewfewa801", "r09gtrez30@") Above statement return "The E-mail supplied is invalid." until I set requiresUniqueEmail="false" in...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.