Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is my SQLserver under attack?

Status
Not open for further replies.

MaxZak

Programmer
Oct 5, 2001
116
IT
Every night (at 3:00 AM) my SQL Server Log reports the message "Login failed for user 'sa'".
At that time I've no Windows' scheduled tasks and no active Jobs (the previous job starts ad 1:30 and ends at 1:45, the next one starts at 4)

I've assumed to be under an attack, but the event is too deterministic (every day at 3).
I've a secure 'sa' password, but I'd like to know if there's someone or something that's trying to violate my SQL server. I think that's a client on my netword because the firewall close the port 1433.
How can I know something more about that strange event?

Tanks
 
You can use SQL Profiler to track logins & hosts. That should give you the computer name if it is on your network
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top