MS SQL Server security - How to stop Login attempts from cerain IP's

Author

How to stop Login attempts from cerain IP's

Martin

2006-01-24, 9:23 am

I have a sql box which is getting loads of login attempts from the sam ip
address. I cannot see where to block ip addresses, windows firewall does not
have usch an option - any body know how. or should i use some other host
based protection?

Ryan

2006-01-24, 11:23 am

You could configure SSL to sucure your communications.

http://msdn.microsoft.com/library/d.../SecNetHT19.asp

--
HTH. Ryan
"Martin" <Martin@discussions.microsoft.com> wrote in message
news:3D2EDA46-051B-4715-8491- DBD46D69058B@microso
ft.com...
>I have a sql box which is getting loads of login attempts from the sam ip
> address. I cannot see where to block ip addresses, windows firewall does
> not
> have usch an option - any body know how. or should i use some other host
> based protection?

Mike Hodgson

2006-01-27, 3:23 am

While I haven't looked into myself at all (so I'm no expert), I would be
looking in the direction of IPSec
(http://www.microsoft.com/technet/it...ec/default.mspx).
There's much there about encryption, which is not what you're after
exactly, but wrapped up in IPSec is also the concept of allowing certain
traffic (protocols & ports) to pass, be secured (ie. encrypted) or
blocked. I'd be looking at setting up some kind of IPSec filter that
blocks the IP (or range of IPs) in question. There's a whole lot of
info on the web about IPSec; the technet link above is a good place to
start in relation to IPSec & Windows.

--
*mike hodgson*
http://sqlnerd.blogspot.com

Martin wrote:

>I have a sql box which is getting loads of login attempts from the sam ip
>address. I cannot see where to block ip addresses, windows firewall does not
>have usch an option - any body know how. or should i use some other host
>based protection?
>
>

Sponsored Links