Attempt to access SQL Server with the user SA

Question

Possible Duplicate:
Attempt to access SQL Server with the user SA

I'm suffering an attempted invasion by brute force. A bot is trying to figure out the sa password. How do I restrict logins 3 attempts in SQL Server?

Moreover, I would like to block an IP, how can I do this?

You should whitelist acceptable IPs and block the rest, instead of blacklisting bad ones and allowing all others. — RexM, May 18 '11 at 15:20
just use the windows firewall. How can I block an ip using it? — ridermansb, May 18 '11 at 15:21

score 1 · Answer 1 · answered May 18 '11 at 15:17

1

You can use a login trigger to restrict access from given ip addresses. I will dig out the code for you.

answered May 18 '11 at 15:17

Duncan Howe

See this link - [http://www.sqlservercentral.com/articles/Security/66151/]http://www.sqlservercentral.com/articles/Security/66151/ – May 18 '11 at 15:21

1 Answers1