How to stop Login attempts from cerain IP's

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?You could configure SSL to sucure your communications.
NetHT19.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
NetHT19.asp
HTH. Ryan
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:3D2EDA46-051B-4715-8491-DBD46D69058B@.microsoft.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?|||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 no
t
>have usch an option - any body know how. or should i use some other host
>based protection?
>