avoiding intrusions - advice please
Posted on 2009-05-08
I'm just beginning sql server and have noticed after opening port 1433 already after less than 3 hours people/robots are trying to log into the sa account.
I've closed the port to the public and left it open for a specif IP but would like some advice on additional precautions I could/should be taking.
Is there a way to lock people out after x attempts or to map "trusted" IPs/profiles.
Is setting up notifications possible for this sort of thng?
Any other advice would be appreciated.
PS using SQL Server 2005 with Management Studio