The life of Brian Kenny
After numerous tactics and fire fighting, dictionary attacks is just
becoming an annoyance for an open SQL server. We have moved behind our own VLAN, in a nice little nook behind the new Cisco ASA series products.
Yet there are still bad login requests reaching our SQL servers. Looks like it’s come to the stage of if (login_failed>100 && IP is the same) {ban ip}
General ranting and raving about things that intreset me. Music, computer games, IT and god knows what else.
I am currently working in Page 7 Media as a Systems Manager. You can contact me by emailing brian@bkenny.com
Conor
September 21st, 2007 at 11:47 pm
If you can you should try build a private lan for your SQL server so you can’t get at it from the internet.
bkenny
September 22nd, 2007 at 10:40 am
Connor,
Unfortunatly - we provide external applications to dialup/adsl users. Due to dynamic IPs we cannot allow a certain amount of IPs and explicitly deny everything else. We also cannot cut communications to the SQL cluster externally.