Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Is there a way to easily block group ip addresses

Author  Topic 

markpringle
Starting Member

11 Posts

Posted - 2011-08-14 : 21:08:36
I get a lot of SQL Server hack attempts via the "SA" account like below..

"Login failed for user 'sa'. Reason: Could not find a login matching the name provided. [CLIENT: 61.147.120.172]"

I've disabled the "SA" account, but is there a way to easily block a group of ip addresses?

Can I use a .htaccess file with window web server 2008 R@and .net? This is a .NET application using SQL Server 2008 R2


"Kindness is not a weakness, the contrary on the other hand is."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-14 : 21:46:42
Block it at the firewall level.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -