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.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-10-25 : 12:24:18
|
| If I fail to login as the system administrator (or other user), it doesn't show up in the system event log. (or am I missing it somehow?).Where does SQL log the login failure? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-25 : 14:08:49
|
| Its in the SQL log, but only if you have "Log failed logins" turned on [you can log "Successful Logins" too if you like)Kristen |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-10-25 : 14:17:28
|
quote:
Originally posted by Kristen
Its in the SQL log, but only if you have "Log failed logins" turned on [you can log "Successful Logins" too if you like)
As in EM, Server Properties, Security tab, Audit Level, Failure?Sam Stay tuned for my upcoming post: "Where's the SQL Log?"I don't want to pick, but you've closed a left bracket with a right paren.  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-25 : 14:27:54
|
| Yup (or All) ... if its a web server then our solution was to move SQL to a non-standard port. Havn't had any failed SA logins since.Kristen |
|
|
|
|
|
|
sa hacking