I am using SQl Server 2005 Express and my client uses SQL Server 2005. We both are getting users who are attempting to log into our servers in the wee hours of the morning using either user names of "root" or "sa". I would like to know is there a way in SQL server itself that after like two failed logins it blocks that IP address entirely from attempting to log onto the SQL server? Any suggestions would be great. We are considering a firewall, but I want to see if there's another option that we might be overlooking without implementing a firewall and it may not still solve the problem.
Robert Williams, Owner
Williams Web Solutions
www.williamswebsolutions.net
info@williamswebsolutions.net
We provide website design & redesign, website & e-mail hosting, dedicated server hosting, and computer/network services.